Post P&L to QuickBooks in Summary

This feature posts the sum totals of order P&L to their specified accounts in Quickbooks. The totals are summed up according to the QB Journal Entry Types below.
The P&L summary is an alternative to posting every order individually with the Post Detailed Sales Order To QuickBooks feature. 
Posting in summary is often preferred, as too many transaction details can lock up your QuickBooks installation.

To post the P&L in summary you need to:
  1. Map the Journal  Entries
  2. Post the P&L from Quickbooks

Mapping Journal Entry Types to QuickBooks Accounts

Journal Entry Types can be mapped to specified Credit and Debit accounts in QuickBooks as well as associating the entry with a specified customer or vendor name. This mapping should be set up by the client's accounting department. Please see the Mapping Guidance section below.

The following Journal Entry Types can be mapped to QB accounts: COGS, Commission, Posting Fees, Promotions, Refunds, Sales, Shipping, Tax, Transaction Fees

Mapping journal entries is a company level configuration with a separate mapping for each channel.
  1. Navigate Settings > Company Settings >  Toolbox > QuickBooks Settings.
  2. Select the Channel and Journal entry type. Then map the account and name fields. Save.
  3. Repeat for all Journal Entry types for that channel.
  4. Repeat for all channels.
Mapping Guidance
  • 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

  1. Make sure that QuickBooks is open and running on the same computer as QuickBridge.
  2. Select QuickBooks from the menu bar.
  3. Select Post P&L to QuickBooks in Summary.
  4. Select a date range, a Company, and a Channel, then press Get Company P&L.
  5. The grid will load with individual orders. However, only the journal entry totals will post to QuickBooks. 
  6. 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.
  7. The "Posting Accounts" section displays the totals of journal entries that will be posted. 
  8. Press the Post P&L to QuickBooks button to export to QuickBooks.

Post General Journal Entries

Starting with version "Post P&L to QuickBooks in Summary" has been replaced with "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.

  1. 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.
  2. 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.
  3. 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".
  4. 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.

How did we do?