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.

How did we do?