[DJobin]

I need to export a set of books for CRA.

Has anyone done this?

What is the best way of doing this?

[MSchappler]

Copy the source application database file and then paste it to a target location of your choosing and then rename the target application database file to an appropriate name. Open your workstation and add a row and select the application database under the file column.

Before entering the target application database, right mouse click Tools > Script Evaluate > and select the following script:

nv2.exe > system > database_id_set.qw_script

Select the target database and click OK.

Enter the target application database and perform the default setup and then re-enter the application database. Remove the transactions from NewViews > Account > Ledgers that you do not wish to be shown using Block > Delete.

Regards to All,

Martin

[DJobin]

Martin,

This is good as a first step. But the next step is more complicated.

CRA wants the data in one of the following formats:

ASCII, fixed length
ASCII CSV
MS Access
MS Excel
DBF
ASCII print report

[MSchappler]

You can use Print > Account Ledgers on your accounts (NewViews > Account > AP and etc ..) and then Set the destination to display which will show the data in Excel. From Excel you can save the spread sheets to files that you can then forward to CRA.

I suggest that you review the Select Columns button in Print > Account Ledgers to choose the columns for your output to Excel.

Regards to All,

Martin

[Author]

Posts