Skip to main content
R
reens80
July 26, 2021
Question

Daily Sales Channels - Reporting Different Sales Channels

  • July 26, 2021
  • 1 reply
  • 0 views

Hi all

 

Not sure if this is the right place. I am new to QBO and not an accountant but get the basics of book keeping.

 

I have just started a takeaway business. I record sales on a Excel spreadsheet by the following categories

 

1. Deliveroo (may be broken down further into Hot Food and Cold food as have diff VAT implications)

2. Uber Eats  (may be broken down further into Hot Food and Cold food as have diff VAT implications)

3. Just Eats  (may be broken down further into Hot Food and Cold food as have diff VAT implications)

4. Online  (may be broken down further into Hot Food and Cold food as have diff VAT implications)

5. Phone  (may be broken down further into Hot Food and Cold food as have diff VAT implications)

6. In Shop  (may be broken down further into Hot Food and Cold food as have diff VAT implications)

 

Deliveroo, Uber Eats, Just Eat deposit the fund into the bank either daily or every other day

Online, Phone, in Shop use a card maching and is on on ePOS 

We have very little cash sales.

 

I would like to enter total daily sales for each of these. I have read this article

Record your total daily sales (intuit.com)

 

I am confused, should I set up the above as 6 different customers?

How many product categories should I set up?

should I set up 6 different sub accounts under sales chart of accounts? 

 

I want to be able to report on the performance all the 6 "channels"

1 reply

C
CharleneMaeF
July 26, 2021

I've got you covered, reens80. I'm here to ensure you're able to record your daily sales in QuickBooks.

 

When recording your customer, you can set up one profile named Daily Sales. I'll show you how.

 

  1. From the left menu, select Sales, then Customers.
  2. Select New customer.
  3. Enter Daily Sales, then select Save.

 

For the correct items, set up a Daily Sales category. This keeps your items organised. To learn more about the process, see Step 3 on Record your total daily sales article.

 

As for the account to use, it's best to set up a separate account instead of using a subaccount. Here's how:

 

  1. Select the Gear icon on the Toolbar.
  2. Under Your Company, choose Chart of Accounts.
  3. Select New at the top right.
  4. Set up these accounts:

I'd also recommend consulting an accountant. They'll be able to guide you on the process to ensure your books are accurate.

 

In addition, to make sure you've recorded the correct total amount of sales in a day, I'd recommend pulling up the Sales by Customer Summary report. Then, set the Report period to Today.

 

Please let me know if you have other questions in recording your daily sales transactions. We're always available to guide you with every step of the process.

R
reens80Author
July 26, 2021

Hi CharleneMae_F

 

The information you have provided doesn't really answer my question. What you have provided I can see is available on the forum in other posts.

 

My question is, if I have 6 different sales channels - should I set up 6 different Daily Sales Customers? or should I set them up as 6 SUB ACCOUNTS under the SALES account in the INCOME chart of accounts or should I set them up as different product categories??

R
reens80Author
July 27, 2021

Hi all

 

Still looking for a solution on how people are setting up daily sales for different channels/brands - especially where they want to see the diff performance

 

Is it different Daily sales customers?

Different Sales sub accounts?

Different products? (as I am recording daily sales - I do not have an extensive list of products - it would just be 2-3. So would I have each channel-product set up as diff products)

 

Thanks

Terms & ConditionsAccessibility statement