does anyone know if there is anyway to record core business transactions on excel and then import to Quickbooks?
We reckon our staff can input to excel 3 times as fast as Quickbooks, we want to know if this is a real possibility??
what we really want to do is create excel files for:
supplier invoices
sales invoices
bank payments
bank receipts
Cash Payments
Cash receipts
other transactions if necessary
is it possible to import these items directly into Quickbooks?
could they be imported on a global spreadsheet or is it better on individual spreadsheets?
is there any risk of overwriting previous data, i.e. can you import for a specific period?
TC
Related resources
Replies (1)
Please login or register to join the discussion.
same question
yes its possible using iif files but i do not think its quicker in the long term because for example of maniftytching payments to bills and reipts to invoices - if yo have an integrated system use it - you can input in MSOA its got a good input routine but same criteria apply
it should bedone on individual spreadsheets and ther is no danger in overwriting
search for importing details on quickbooks there are a number of templates on the web - the files are .iif