How do I reconcile sales invoices with Amazon bank payments in QuickBooks?

How to match Amazon bank payments to Taxomate sales invoices in QuickBooks.

Settlements can be sent to QuickBooks as sales invoices, which you can match against your bank payments.

Please note: We recommend turning on Receive payment in Settings > Invoice in Taxomate. It appears when Post as is Sales invoices. It records the payment on the invoice, which makes matching with your bank deposit easier.

1. Reconciling single invoices / payments

STEP 1. First, make sure you picked the right bank or credit card account for each marketplace. Go to Settings > Connections, select Manage marketplace mappings, and check Payout bank account (and Negative payout bank or credit card account) for each marketplace.

STEP 2. In QuickBooks, select Banking on the left side.

STEP 3. Find the Amazon deposit for the invoice/payment you want to reconcile.

STEP 4. Select Confirm to reconcile your invoice/payment with your bank deposit.

If Match is not shown, select Find Match to search for the invoice/payment.

2. Reconciling split invoices / payments

If Split settlements across months is on (Settings > Invoice, under Currency and months), Taxomate sends two invoices where the settlement spans two months (for example, Sep 19, 2019 - Oct 3, 2019). If Receive payment is off in Taxomate, QuickBooks may not match them automatically, and matching is slightly different.

STEP 1. As with single invoices, select Banking on the left side and find your Amazon deposit.

STEP 2. If Receive payment is on, QuickBooks will usually match the deposit for you and you see a Confirm button.

If not, select the deposit and then select Find Match in the dropdown. Select the two invoices (or the single payment) sent to QuickBooks. The difference should total $0.00.

STEP 3. Click save and you see a Transaction Matched notice.

Reconcile Journal Entries in QuickBooks

Did this answer your question?
😞
😐
😁