• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Intuit Products   QuickBooks Online (US)  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
258
cF1ybwtPSr4yUOacwZ5xHE
Subscribe RSS
CaffeDei
CaffeDei
Questions asked: 3
Questions answered: 5
Points earned: 5
CaffeDei
CaffeDei
Questions asked: 3
Questions answered: 5
Points earned: 5
New Member
02/03/12 11:16am PST
Viewed by asker 02/08/12 1:17pm PST

Entering info for multiple departments

US QuickBooks Online Edition : Online Plus with Payroll

I own a coffee shop and use QBO (obviously) and i have an issue.

To enter my daily sales, and to keep things tidy, i enter things to different departments. For example:

1.) Beverages. I put in the amount made in beverages and from the Department drop-down menu, ill choose Beverages, which i previously setup.

2.) Pasteries. I follow the same proceedure.

My question is, is there a way to enter all this information at once?

It is very tedious to enter one department at a time and it would go MUCH faster to enter all my information (beverages, pasteries, sandwiches, misc), enter the amounts made for each one, THEN assign them to the proper department.

Is this even possible?

Thanks for any help!!

-Shane

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
11 Replies
missamy_qbo
missamy_qbo
Questions asked: 0
Questions answered: 10
Points earned: 20
missamy_qbo
missamy_qbo
Questions asked: 0
Questions answered: 10
Points earned: 20
Employee
02/07/12 11:42am PST

Did you use classes or locations to set this up?  Have you considered using a recurring template that already has this data populated so you can simply fill in the amounts each day/week? 

 

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
CaffeDei
CaffeDei
Questions asked: 3
Questions answered: 5
Points earned: 5
New Member
02/08/12 7:24am PST

 im gonna go with a solid "no" on this one as i have no idea what your talking about.

what are "classes" or "locations"?

heres my normal, end of day routine:

 

-Customers

-Sales Receipt

-Department (beverages, pasteries etc etc)

-Product (again, beverages, pasteries etc etc)

-Description (usually "What i did for today")

-Amount (the amount i did for the day in that particualr category)

-Save

Then i move onto the next Department.

So, is there an easier way to do all this? Like i stated, this is very tedious and time consuming.

I understand that QBO wasnt built for a Coffee Shop, but it does work "fairly" well, just wish it could work better. But if there is an easier way, please tell me!!

 

-Shane

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
rkilbride
rkilbride
Questions asked: 4
Questions answered: 173
Points earned: 336
Allstar
02/08/12 9:59am PST

If you set up different sales items going to the proper accounts you could just do them all on one sales receipt quite quickly.  Just make a sales item for each department going to that department's sales account.  Leave the description blank and enter the product(s) there.  Enter the amount and then move on to the next line and do the same for the next department. 

Alternatively, you could set up an item for everything you sell.  When you sell some of that item you just drop in the quantity and then you will have more detailed reports as well showing you quantities of every item you sold over a period of time.  That would help you with ordering as well.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
CaffeDei
CaffeDei
Questions asked: 3
Questions answered: 5
Points earned: 5
New Member
02/08/12 10:35am PST

im not quite sure i understand what you mean by your first paragraph.

i tried entering each category on each line, then adding the amounts made in each category that day, but that doesnt work because you can only add into one department at a time.

thats the issue im running into.

theres gotta be a way to enter info into multiple different departments in one shot instead of doing it one department at a time.

thank you for your reply!! i appreciate it!

-Shane

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
host_sherrie
host_sherrie
Questions asked: 28
Questions answered: 3205
Points earned: 5746
Host
02/08/12 10:43am PST

You can use Class Tracking for your departments.  Then you would be able to specify a class on each line item of the Sales Receipt.  Here's a link with additional information on using class tracking. 

support.qbo.intuit.com/support/answers.cfm

Have a great day!

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
rkilbride
rkilbride
Questions asked: 4
Questions answered: 173
Points earned: 336
Allstar
02/08/12 10:50am PST

Okay, I'l try this again.  I'm not sure how you're handling these various departments exactly, but here is how I would handle the situation as I'm reading it.

Set up a sales account for each department in the chart of accounts.

Create a different item for each department in the Products and Services List that goes to the proper account leave the Description blank.

When creating the sales receipt choose the department you want to enter under the Product/Service enter a description of what you sold and the dollar amount.

Go to the next line and do the same for the next department until you are finished with everything.

Done.

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
CaffeDei
CaffeDei
Questions asked: 3
Questions answered: 5
Points earned: 5
New Member
02/08/12 12:16pm PST

 ohhhhh, i gotcha "rkillbride"!! that makes sense now!

thank you for explaining that a bit better! kudos!!

last question, will this be seperated when i look at the overall "company outlook" or "PNL" list?

-Shane

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
rkilbride
rkilbride
Questions asked: 4
Questions answered: 173
Points earned: 336
Allstar
02/08/12 12:33pm PST

Yes the revenues will be seperately listed on the P&L if you use seperate income accounts.  I break up my "accounting" and "tax" income in this manner and it works great. 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
CaffeDei
CaffeDei
Questions asked: 3
Questions answered: 5
Points earned: 5
CaffeDei
CaffeDei
Questions asked: 3
Questions answered: 5
Points earned: 5
New Member
02/08/12 12:34pm PST

 ok, so i just ran a "test" for yesterday, as i was closed.

i setup everything like you said, "rkillbride", but under the Sales By Department Detail Report, it shows up as Not Specified.

what did i do wrong?

-Shane

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
rkilbride
rkilbride
Questions asked: 4
Questions answered: 173
Points earned: 336
Allstar
02/08/12 12:45pm PST

I don't have a report called Sales By Department Detail.... I do have one called Sales by Product/Service Summary and that works for me.  You may have a different version of QBO than me (I only use the basic) or have a feature I am not aware of turned on. 

If you run a Profit & Loss report for the day in question it should show a breakdown by department for you.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
CaffeDei
CaffeDei
Questions asked: 3
Questions answered: 5
Points earned: 5
New Member
02/08/12 1:17pm PST
Latest post

 ok, yeah, i ran a PNL and i see it.

im just used to seeing things under the department listing.

thanks again! i really appreciate all your help!!!

-shane

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • online plus with payroll
  • us quickbooks online ed...
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
DWLCPA
1 min ago
DWLCPA
posted
Tax Import and File Indexing
RasSteven
1 min ago
RasSteven
posted
Whitch Store is less expens...
curious52
2 mins ago
curious52
posted
add bank information
Vickigogreen
2 mins ago
Vickigogreen
posted
Cost of goods
Bev410
2 mins ago
Bev410
replied to
Report format-alignment change
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business