Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI have recently been asked to handle the accounting department for a friend who just purchased a convenience store. I am fairly new at this and have been researching nonstop but seem to never find what I need to do. Long story short, we have QBO and I enter all our daily sales onto a spreadsheet. It shows the breakdown of the total sales of each account. (groceries, beer, wine, tobacco, etc) It shows how much money was br
ought in and such as well. I need to put those amounts into QBO each month. I do have the bank account connected to QBO so everything that goes through the account comes into QBO.
I have a journal entry template set up but I am feeling though I am doing it wrong.
I have Debited the following
Cash
Checks
Local Charge Pay In (when they pay on their account)
Then I credited these
Local Charge Account (when they charge to account)
COGS-Groceries
COGS- tobacco
COGS- Alcohol
We also sell scratch off lottery tickets, I am not sure how to account for the money in and the money we pay out.
I am hoping I can get some help, I should have asked long ago and now I am scrambling.
Thank you!
You can prepare Sales Receipt data with the following template
RefNumber | Customer | TxnDate | ShipDate | ShipMethodName | TrackingNum | Location | Class | BankAccount | PaymentMethod | PaymentRefNumber | BillAddrLine1 | BillAddrLine2 | BillAddrLine3 | BillAddrLine4 | BillAddrCity | BillAddrState | BillAddrPostalCode | BillAddrCountry | ShipAddrLine1 | ShipAddrLine2 | ShipAddrLine3 | ShipAddrLine4 | ShipAddrCity | ShipAddrState | ShipAddrPostalCode | ShipAddrCountry | PrivateNote | Msg | Currency | ExchangeRate | BillEmail | ToBePrinted | ToBeEmailed | ShipAmt | ShipItem | TipAmt | DiscountAmt | DiscountRate | TaxRate | TaxAmt | DiscountTaxable | LineServiceDate | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineClass | LineTaxable |
101 | Janice Johnson | 01/10/2020 | Checking | Check | 20013 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | [email address removed] | N | Y | 0.02 | Y | Leather Case | Leather Case | 2 | 10 | TAX | ||||||||||||||||||||||
101 | Janice Johnson | 01/10/2020 | Checking | Check | 20013 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | [email address removed] | N | Y | 0.02 | Y | Gift Cards | Gift Cards | 2 | 5 | TAX | ||||||||||||||||||||||
102 | Leonard Walker Inc | 01/10/2020 | Checking | Cash | paid cash | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | [email address removed] | Y | N | Y | Handhelds | Portable Game Player | 1 | 100 | TAX |
then use an importer tool to proceed.
https://get.transactionpro.com/qbo
I do not have customers. I am just wanting to enter one monthly journal entry to show the sales for the month.
There's a lot going on there. The local charge account is offset by sales (revenue) when they put the charge on account, not COGS. When they pay down their charge account, it is offset by cash, check or cc, depending on how they pay. I've have no experience with lottery ticket sales. If you can provide more info on how that works, I can try and help. The journal entry to record sales will look something like this:
Debit | Credit | |
Cash | XXX | |
Checks | XXX | |
Credit Card | XXX | |
Merchant (CC) fees | XXX | |
Local Charge Account (when they charge to account) | XXX | |
Sales (Revenue) | XXX | |
Sales Tax Payable | XXX | |
Local Charge Account (when they pay in - same as charge account) | XXX |
COGS is offset by a reduction in inventory so any journal entry that records COGS needs to have an offsetting amount of inventory. You can include it in the journal entry above or a separate entry like this:
Debit | Credit | |
COGS | XXX | |
Inventory | XXX |
I forgot to mention that if you record COGS, you will need to include inventory purchases as well. Since COGS reduces inventory, you will need to add inventory each month. That leads to Accounts Payable and so on... If you just want to use QB for tracking sales, then omit the COGS/inventory journal entry. I'm sure you're you're aware that the bank balance won't be accurate unless you're tracking all expenditures (expenses, inventory purchases, etc.).
@Rainflurry Thank you so much for your help! You have no idea how thankful I am.
For the lottery sales, The state drops off the scratch tickets. We are not charged for them. When someone purchases one, we take the money and run it all through the POS system. If someone has a winner, we pay them. The company then will do an automatic withdrawal depending on how many we sold less what we paid out. I am unsure how to handle these sales.
I tend to OVERTHINK a lot and second guess myself... Now I am so behind and have already reconciled the bank accounts but they do not show the sales... So that will prob be a huge nightmare lol Again, thank you so much!
With your first journal entry, is there a way to enter the COGS on there? To show what the sales were for ?
"With your first journal entry, is there a way to enter the COGS on there? To show what the sales were for ?"
On the first journal entry, you can create multiple sales accounts or subaccounts for groceries, liquor, etc. to track sales. COGS is an expense so unless you're tracking inventory in QB, it doesn't make sense to use COGS expense.
In regard to recording the lottery sales, payouts, etc. (commissions on sale of tickets?), that sounds like a pretty in-depth discussion and I would suggest you see if you can find others on other forums that have done this. I have no experience with it.
Hi. Have you got solutions for these kind of transaction? I am also need recording monthly sale of same kind of transaction.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here