LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
2sCo
Level 1

I have a point of sale system that does not integrate with QBO, so how do I deal with categorizing my bank transactions (sales deposits, inventory purchases, etc)?

My POS handles everything (sales, purchase orders, inventory and such), so I am trying to use QBO for book keeping only. I am categorizing inventory purchased under "Inventory Asset", but how do I deal with noting the sale of said inventory, and the deposits of money taken in for those sales? I've been looking at the various questions, but every answer has you running your store through QBO.
4 Comments 4
Rainflurry
Level 15

I have a point of sale system that does not integrate with QBO, so how do I deal with categorizing my bank transactions (sales deposits, inventory purchases, etc)?

@2sCo 

 

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.

Fiat Lux - ASIA
Level 15

I have a point of sale system that does not integrate with QBO, so how do I deal with categorizing my bank transactions (sales deposits, inventory purchases, etc)?

@2sCo 

Which POS system do you have? You may consider having a 3rd party connector.

2sCo
Level 1

I have a point of sale system that does not integrate with QBO, so how do I deal with categorizing my bank transactions (sales deposits, inventory purchases, etc)?

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. 

Rainflurry
Level 15

I have a point of sale system that does not integrate with QBO, so how do I deal with categorizing my bank transactions (sales deposits, inventory purchases, etc)?

@2sCo 

 

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us