Skip to main content
May 8, 2024
Question

Issue with Quickbooks native Shopify integration. The P/L statement records sales as NET values. How do you record Gross values to deduct all fees correctly?

  • May 8, 2024
  • 1 reply
  • 0 views
The profit and loss statement records sales as NET values, and discounts, adjustments, and Shopify fees are deducted from this value.

Gross values should be recorded to deduct discounts, adjustments, and Shopify fees correctly.

1 reply

May 8, 2024

Thank you for sharing your concerns and reaching out to the Community, Andrius-lebedeva.  

 

The Profit and Loss report displays your company's revenues, expenses and net income over a certain period, typically one year. The bottom line on the Profit and Loss statement shows the Net Income.  

 

On the other hand, we can review and add payouts to your accounts. Payouts are payments received from your sales channel for completed orders. Each payout includes the sales amount, discounts, refunds, expenses, and adjustments for the orders in the payout period. 

 

Once you connect your sales channel, QuickBooks will automatically import the latest transactions. 

 

Here's how to can add them to your books:

  1. Go to Transactions.
  2. Select App transactions.
  3. Select your sales channel from All Connections, then select For Review.
  4. Select a payout, then select an option in the Action column:
    1. Add: This payout is ready to be added to your books.
    2. View details: expands the details, such as the breakdown of the sale income, refunds, and expenses.
    3. Exclude: This payout won’t be added to your books.
  5. If you need to undo a payout you’ve added to your books, go to the Review tab and select Undo under the Action column.

 

I'll include this helpful resource for more information on this process: Review and add payouts to your books in QuickBooks Online with Commerce.

 

For future reference, if you’d like to automatically add Payouts to your books, feel free to visit this link: Automatically add payments.

 

If you have any more queries regarding Shopify integration or any other QuickBooks-related matters, feel free to reply to this thread. I'll be more than happy to assist you further. Keep safe.

AndriusLAuthor
May 8, 2024

This part of your provided information is not correct:

 

"On the other hand, we can review and add payouts to your accounts. Payouts are payments received from your sales channel for completed orders. Each payout includes the sales amount, discounts, refunds, expenses, and adjustments for the orders in the payout period. " 

 

Each payout doesn't include discounts, refunds, expenses, and adjustments. We get this payout in our bank account with deducted discounts, refunds, expenses, and adjustments.