Skip to main content
S
shirley bpr
February 14, 2024
Question

Importing sales information from Epos or other SW

  • February 14, 2024
  • 1 reply
  • 0 views

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

1 reply

A
Ashleigh1
February 14, 2024

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. 

S
shirley bprAuthor
September 16, 2024

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.

P
payment after leaving
September 16, 2024

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-deposits-quickbooks-online/L2BBZOPdr_GB_en_GB

Terms & ConditionsAccessibility statement