How to use 1-Click Accounting for Amazon to post settlement, orders and refund data to QuickBooks Online
After you have completed the setup of how Unify will post your settlement report, transactions, items and refunds in context of the 1-Click Accounting for Amazon, you will be ready to use this feature. Since 1-Click Accounting for Amazon is a global posting function, this feature is triggered when the settlement report is posted to QuickBooks Online.
Step 1: Select the Expenses icon and select marketplace fees
Step 2: Select the settlement report that is ready for your to post to QuickBooks Online and click confirm to sync
Note: only one settlement report can be posted to Quickbooks at a time.
After the settlement report is posted to QuickBooks Online, you will see a green confirmation box and there will a green check mark in the Sync column. If you hover over the check mark, Unify will display the bill in QuickBooks Online that is created during this process (as shown below):
Step 3: Viewing the settlement report bills in QuickBooks Online
Reconciliation or bank feed data and deposit matching is a one step process in QuickBooks Online. When looking at the data in the context of Unify, these are the data points and how it corresponds with the data in QuickBooks Online. Below is what the data looks like in Unify after a successful settlement post:
Here is what the data looks like in QuickBooks Online (viewing Bank Deposit):
Step 4: Reconciling settlement report data in QuickBooks Online
When Amazon sends you the revenue at the end of a settlement period, it will directly deposit into the account you specified when you created your seller central account. That bank account should be in the general ledger of your chart of accounts and should have a data feed that displays revenue that is applied/sent to that account. And in this case, directly from Amazon at the end of a settlement period.
a. Go to the Banking menu and click on the For Review area which shows all the deposits and bank feeds from your accounts:
When 1-Click Accounting for Amazon is enabled in the process of posting the settlement data, Unify will also posts all orders, refunds and the settlement data for the settlement report that is posted.
b. Click on Match, to match the deposit feed from your bank with the deposit of the settlement data and you should see a successful message:
To view your matched transaction click on the In QuickBooks area to see the deposit that has been matched with the revenue in the bank feed (as shown below):