How ConnectBooks records Amazon loans
ConnectBooks brings in Amazon loan transactions with a service item called Amazon Loan. It's linked to a loan account, which is an Other Current Liability account. To see which account, go to Stores & Files and click your store. On the Accounting tab, under Accounting Settings, click Settings. Then open the Advanced Mapping tab and look under Loans.
When Amazon pays you the loan (usually as part of a settlement), ConnectBooks makes an invoice for the loan amount with the Amazon Loan item. This raises your loan balance.
Each time a loan payment comes out of a settlement, ConnectBooks makes a credit memo with the same item. This lowers your loan balance.
If your store has Export as Journal Entries turned on, ConnectBooks makes a journal entry instead, to the same loan account.
ConnectBooks can't see your loan statements, only the payouts and payments. So you need to record the interest yourself at the end of the loan.
If you already have a loan when you start
New QuickBooks file: first record the loan balance you still owe in the loan account ConnectBooks uses (see Advanced Mapping, under Loans).
Existing QuickBooks file: switch or merge the account you used for the loan into the loan account ConnectBooks uses. Or have ConnectBooks use your own loan account (see below).
Use your own loan account
In ConnectBooks: open your store's Advanced Mapping tab the same way. Under Loans, in the Override QuickBooks Item column, pick an item linked to your own loan account. If your store uses journal entries, pick your loan account in the Override Account column. Click Save.
In QuickBooks: after ConnectBooks brings in a loan payment or payout, go to the Item List and open the Amazon Loan service item. Link it to your loan account. QuickBooks can also move past entries that used this item to the new account. This works only for invoice and credit memo stores, not journal entry stores.
Record the interest
After the loan is paid in full:
Download your loan statement from Amazon Seller Central.
Find the total interest you paid over the loan.
In QuickBooks, make a journal entry that debits Interest Expense for the interest, and credits your loan account.
Your loan account should now show $0, unless you took another Amazon loan.
Watch how to record the interest:
Frequently asked questions
Why doesn't my loan account go to $0 after the last payment?
The payments include interest, which ConnectBooks doesn't see. Record the interest as shown above.
Can I use my own loan account?
Yes. Map it in Advanced Mapping under Loans, or link the Amazon Loan item to your account in QuickBooks. See "Use your own loan account" above.