Syncing Revel to QuickBooks

By Amelia Dwyer

Follow

How Transactions appears in QBDT from Revel:

Sales

  • 1 invoice per day
  • Payment Summary mode
    • 1 Payment per Method per day
    • 1 Credit memo per method per day for Refunds
  • Payment Reconciliation mode
    • 1 Payment per payment created in Revel for all credit card type
    • 1 credit memo per refund
    • 1 payment per method per day for Cash, Other
    • 1 credit memo per method per day for Cash, Other

Inventory

  • 1 Bill per day for all manual receive through Inventory
  • 1 Bill per day per PO for all receive done through PO
  • 1 JE per day per action through Inventory for all other action (Use, Damage, etc.)

Payout

  • 1 JE per Pay-out/Pay-in transaction in Revel.

How Sales, Payments and Refunds appears in QBDT from Revel:

  1. Sales are summarized into a single Invoice.
  2. Payments
    1. Cash goes to Cash in Hand
    2. All other payment methods goes to Undeposited Funds
  3. Card refunds are handled through creating a ARRefundCreditCard
    1. All Other Payment Credit Memo
    2. Credit methods are handled through creating a Check

How Inventory appears in QBDT from Revel:

  • Receive at Revel handled as Bill in QBDT.
  • Track in Inventory items in Revel go to Inventory asset.
  • Non Track in Inventory Items in Revel go to Cost of Goods Sold.
  • Any other action in Revel Ex - Use, Damage, Return are adjusted using Journal Entry to application accounts.

How Payins and Payouts appears in QBDT from Revel:

  • Pay-outs and pay-ins in Revel goes to QBDT as Journal Entries.

Daily Sync Process Diagram:

  1. Pull data from Revel backend API.
  2. Receive response from API.
  3. Sends to QBDT.
  4. QBDT sends response.
  5. Process response and store QBDT IDs for successful request. Any kind of error or exception goes to Log.
  6. Sync continues.


Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request
Still have questions? Contact our friendly Support team

Join us to learn and celebrate at Revelry, Oct. 12th - 13th. Take 50% off registration with promo code: SUPPORT50

Learn More