Post P&L to QuickBooks in Summary
- Map the Journal Entries
- Post the P&L from Quickbooks
Mapping Journal Entry Types to QuickBooks Accounts
- All names being used when Mapping Journal Entry Types to QuickBooks Accounts must match exactly to their corresponding names in QuickBooks. Otherwise, an error will occur on export.
- The Debit Name and Credit Name refers to either a customer name or a vendor name that will be associated with the transaction. Because this feature posts order P&L in summary, you should be using a generic name for the sales channels - e.g. Amazon Customer.
- The generic customer and vendor names should be set up in QuickBooks prior to posting P&L in summary.
- When posting to an Accounts Payable account type, the QBCustomerFullName must be set up as a vendor in Quickbooks, not as a customer.
Posting P&L in Summary to Quickbooks
- Make sure that QuickBooks is open and running on the same computer as QuickBridge.
- Select QuickBooks from the menu bar.
- Select Post P&L to QuickBooks in Summary.
- Select a date range, a Company, and a Channel, then press Get Company P&L.
- The grid will load with individual orders. However, only the journal entry totals will post to QuickBooks.
- Under the "Posting Information" section, you can press the Accounts button to view the the account mapping and the total that will be posted to each account. The account fields are editable and can be saved back to SellerCloud.
- The "Posting Accounts" section displays the totals of journal entries that will be posted.
- Press the Post P&L to QuickBooks button to export to QuickBooks.
Post General Journal Entries
"Post General Journal Entries" works the same way as "Post P&L to QuickBooks in Summary" however it is transaction based, which accounts for each transaction independently.
In addition, the following features have been added to simplify reconciling with the channel payment.
- Transactions that are related to a settlement can be filtered by SettlementID. (Currently this is only relevant to Amazon and FBA.) Entering a SettlementID will override the Trans Start Date and Trans End Date.
- Additional Journal Entry Types have been added for Amazon non-order
related transactions, which can be mapped to specified Credit and Debit accounts in QuickBooks as well. Such as FBAInboundTransportationFee, Storage Fee, RemovalComplete, ServiceFee, Subscription Fee, etc.
- Added the ability to filter by order related fees and non-order related fees. (Currently this is only relevant to Amazon and FBA). This can be useful to bring in the non-order related fees when using "Post Detailed Shipped Orders to QuickBooks".
- Added a checkbox to each line with the ability to include/not include a transaction(s) in an export. The checkbox in the header will check/uncheck all (by default all transactions are checked). This can be useful if you would like to have one journal entry type mapped to two different QB Accounts. You can separate the transactions and make a second posting with the specified mappings.