cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
shirley bpr
Level 1

Importing sales information from Epos or other SW

We are a Small charity with 4 shops - will go to EPOS shortly and also animal shelter manager software.

If the sales are recorded through these sources, can I upload to QB via CSV or automatic rather than at present manually typing in everything?

 

Thanks

5 REPLIES 5
Ashleigh1
QuickBooks Team

Importing sales information from Epos or other SW

Hello Shirley bpr, thanks for posting on the Community page, you can import sales receipts into QuickBooks and in bulk, this article has all the steps you need. 

shirley bpr
Level 1

Importing sales information from Epos or other SW

Thanks Ashleigh, that part I get, its more the double entry side I am confused with.

Worldpay / stripe/ sum up or even banked cash - there are already sitting in Quickbooks in the bank ready to allocate.

If I then upload a sales receipt - where does this post to then match the payments in the bank?, these could be multiple entries for the day so various customers / codes etc.

I get a sales invoice we post the bank payment to the invoices / customers to clear them.

John C
QuickBooks Team

Importing sales information from Epos or other SW

Hi shirley bpr If you upload the sales receipts into QuickBooks via CSV they will post to the bank account you have allocated them to on the CSV. You will then be able to match the receipts to the amounts on the banking page, however please note, if the amounts aren't the same you'll not be able to match them. The amounts could differ if you have received one payment that relates to a number of sales receipts or if you have received an amount that is less than the amount of the sales receipts due to having incurred fees.

If you have received one payment for a number of invoices you could allocate the sales receipt to the undeposited funds account rather than your bank, create a bank deposit, ensure the bank account and date are correct, select the relevant sales receipts, ensure the amount is the amount you received, save and close. You should now be able to match the deposit amount to the amount on your banking screen. Similarly, if you have received an amount that is less than the sales receipt due to incurring fees you would use the same method above however you would add the fees to the 'Add funds to this deposit' section, select the appropriate expense/fee account in the account field, enter the amount of the fee as a negative, apply VAT where appropriate, save. You should then be able to match the net amount to the amount showing on the baking screen.

We've included an article that references the above: https://quickbooks.intuit.com/learn-support/en-uk/help-article/bank-deposits/record-make-bank-deposi...

shirley bpr
Level 1

Importing sales information from Epos or other SW

thanks I am trying but it will not let me put in sales receipt number:- I can try 1 it fails, 1001, it fails, leave blank it fails, the date it fails.

What should I put in and what format? same for sales invoice - will it or can it not be left blank to auto generate the next number?

GeorgiaC
QuickBooks Team

Importing sales information from Epos or other SW

Hi shirley bpr, thanks for getting back in touch

 

The transaction number is a required field when importing sales receipts and sales invoices in QuickBooks Online. By default, QuickBooks applies a numerical numbering system when you begin entering transactions, but you can turn on custom transaction numbers where you can enter any number or letter format you want. 

 

To troubleshoot, please check all transaction number fields and filled and then try uploading the CSV file by signing into QuickBooks through an incognito browsing window (if using Chrome, press Ctrl + Shift + n to open the new window). 

 

Thanks for reaching Intuit support. We'll be here if you need any further assistance. 

Need to get in touch?

Contact us