Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
LIMITED TIME 90% OFF QuickBooks for 3 months*
Buy now
We have a business that has the exact same scenario. From an accounting perspective, this could be a very in-depth discussion.
You will need to enter a daily sales receipt in QB. You can set up a template called daily sales or something similar. The way I do it is to create items for taxable sales, non-taxable sales, gift cards paid in (redeemed), gift cards paid out (sold) and cc payments. I also set up accounts for sales tax adjustment (QB doesn't round the same as our POS) and cash over/short to adjust the deposit for days when cash is off. The taxable and non-taxable sales and gift cards paid out are entered on the sales receipt as positive values. The payments received (cc and gift cards paid in) are negative. That will leave the cash sales on the sales receipt to be deposited into your bank account. This way you will have accurate cc and cash deposits to reconcile at month-end.
As far as inventory goes, you can add to inventory using bills (as you're doing) and then create a daily journal entry, debiting cost of goods sold (COGS) and crediting inventory for each day's sales. That report should be available in your POS. That option is the most labor-intensive as it requires daily entries. This method gives you accurate financial statements from any given day to another since you have accurate daily numbers.
The other option for tracking inventory is to use what's known as the periodic method of inventory. This saves you a lot of time by assigning all of your inventory purchases to a temporary 'Purchases' asset account and then creating just one journal entry at month-end to allocate those purchases between ending inventory and cost of goods sold. This creates an accurate P&L only at month-end which, for most businesses, is fine.
Which POS system do you have? You may consider having a 3rd party connector.
Rainflurry,
Thank you so much for all of your answers. You have been incredibly helpful. I have a quick question for you.
We issue Store Credits/On Account transactions and I need to get them onto my Daily Sales Receipt template. How would you categorize those/set them up in the COA? I can create a "Service" item for them & I know they are income, but what Income Account do you use to direct the money too? Hope this makes sense- Thanks.
For transactions 'On Account', you would need to use an invoice, not a sales receipt, because those transactions should be posted to Accounts Receivable (A/R) since you are expecting to get paid in the future.
'Store Credits' are, technically, liabilities since you owe the customer something in the future. The best way to record those is to use a Credit Memo (New > Customers > Credit Memo). QBO books those as a reduction in A/R (as opposed to a liability), but both are considered a credit in double-entry accounting so it works. A Credit Memo will keep the balance as a credit that can be applied to a future invoice or sales receipt for that customer.
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