Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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.
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.
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...
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?
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.
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.