Skip to main content
CarpSoc
Sep 17, 2021 1:40 PM UTC
Question

Importing daily till transactions into QB

Help, new to QB and i'm not finding the answer in any of the online help videos 

we use a till system which unfortuanately wont connect to QB but we can export a csv file of the daily transactions. 

 

We have previously used sage and was able to import this 'audit transactions' upload. does anyone have any advice how we can do this in QB 

 

 

6 replies

EmmaM
Sep 17, 2021 2:05 PM UTC

Hello CarpSoc,  You can import invoices, sales receipts, ban data, journals, credit notes, customers, suppliers, chart of accounts, products, and services, all within the import data tab in the settings cog on the right. If you are looking to add specific audit information for your accountant can we just ask a little bit more detail, where do you want them to show in terms of accounts? 

CarpSocAuthor
Sep 17, 2021 2:16 PM UTC

This is one report from daily till transactions so will be a number of functions in one report 

for example 1st June 2021

 

Sales payment received into bank account /CC 

Sales payment refund into bank account / cc

 

Sales Invoice/credit  transactions to each nominal code

 

often there are multiple ways the payment comes in. 

 

 

 

 

EmmaM
Sep 17, 2021 3:42 PM UTC

Hello CarpSoc, Do you want it to just record against the bank account/chart of accounts or are you also wanting it to create sales receipts/credit notes/invoices from this upload?

Terms & ConditionsAccessibility statement