Skip to main content
January 24, 2023
Question

Creating a monthly sales summary in QBO (Canada)

  • January 24, 2023
  • 1 reply
  • 0 views

Good afternoon,

I am a fairly new QBO user (though not new to bookkeeping) and am having difficulty creating a monthly sales summary entry. I would like to do something along the lines of creating a daily sales receipt (as discussed in QuickBooks Help) in order to manually enter our ecommerce sales once a month. How do I do this when there are two separate sales taxes that we collect on some but not necessarily all of the sales? Sales taxes are set up in QBO. I tried to create a general journal entry; however, I found that if I did not choose an option for the sales tax field then no sales nor sales taxes would show up in the tax reports or if did then QBO would calculate it own incorrect tax amounts assuming that all the sales were subject to both taxes. Is there a way around this? 

1 reply

January 24, 2023

Hi TKP79,

 

It's nice to see you here.  Welcome back!  It's essential that you're able to enter your daily sales seamlessly and view your entries at a glance with QuickBooks Online reports.  I'd be glad to assist!

 

You can record your daily sales in one sales receipt that will keep your income reports accurate and save valuable time.  Your sales tax will be entered per line item to ensure it transfers to the associated reports.   This eliminates the need for journal entries.  Here's a helpful guide for your reference.  When you're ready to run a report, I suggest the Sales by Customer Detail report.  Once you've entered the desired Report Period, you can click on the small in the top right and add additional customization options as you feel necessary.  

 

Please feel free to reach back out if you have any other questions.  We're always happy to help!