Importing data into CCH AP

Importing data into CCH AP

Didn't find your answer?

So we upgraded from Viztopia to CCH Accounts production, and most of our clients use an in-house basic bookkeeping software. The transaction data is exported to a CSV file which was imported to viztopia. This CCH will help with.

I also want to be able to import both transactions and TBs from external software such as freeagent and xero into CCH accounts production.

I've not had much luck with CCH.

I believe a mapping file needs to be set up but the CCH instructions are pretty confusing!

Anyone do any better?

Andrew

Replies (1)

Please login or register to join the discussion.

avatar
By ChrisDL
27th Aug 2014 12:23

Not tried Xero but...

The key to it is getting the file structure right:

Go into Maintenance>Accounts>Import/Export Definitions>File Structure

Create a new one and fill in the formatting section - the key ones are the file type (csv etc) and the number of fields in the file you are importing (including any blank columns) and the import type (transactions / tb)

For however many fields there are a list will appear with position (columns 1 onwards working left to right) and you specify the AP field for each one, leaving the blank fields as None.

Save it off with a suitable name and that should get you going - you can then go and create the nominals mappings off the same menu in maintenance

Thanks (1)