Reconciliation with Cin7 Pay and QuickBooks Online
Overview
This article explains how Cin7 Pay transactions sync to QuickBooks Online and how to reconcile payments, fees, surcharges, and payouts.
Transactions created by Cin7 Pay
Cin7 Pay creates the following transactions:
Payments
Payment fees
Surcharges
Payouts
Transactions that must sync for reconciliation
This table shows which transactions must sync to QuickBooks Online for reconciliation. It includes every transaction recorded by Cin7 Pay, as well as the underlying invoice or credit note.
Transaction |
Note |
|---|---|
Invoice |
Required |
Payment |
Required |
Payment fee |
Required |
Surcharge |
Required only if surcharges are activated |
Payout |
Required |
Credit note |
Required for refunds and returned goods |
For instructions on creating refunds or returns, see Cin7 Pay refunds and disputes.
How transactions reconcile
This table shows how Cin7 Pay transactions reconcile in QuickBooks Online.
Transaction |
Debit |
Credit |
|---|---|---|
Invoice |
Accounts receivable |
Sales |
Credit note |
Sales |
Bank account |
Surcharge |
Accounts receivable |
Surcharge or sales income |
Payment |
Clearing |
Accounts receivable |
Payment fee |
Payment fee (expense) |
Clearing |
Payout |
Bank account |
Clearing |
Because refunds are deducted from upcoming payouts, no separate bank transaction is created when a refund is issued.
Reconciling payments against quotes and sales orders
You can receive payments against quotes and non-invoiced sales orders via Invoice Pay Online and merchant-initiated transactions.
These payments can’t sync to QuickBooks Online until the quote is accepted and the sales order is invoiced.