Hi Darcy,

By 'tweaking', I mean that the exported transaction Excel file for current year transactions must be in a format that is importable as a 'Detail only' style batch. Essentially you need to determine what fields/columns to export in the first place, so you can them import them back in as a batch. Take a look at the default 'Detail only' batch template for an idea of what is required. Also look at the help file for importing batches to see what fields are required and which ones you can get away without including in an import batch file.

Before importing batches to the current year, or transactions to a historical year, you first have to import the opening balances for each (balance sheet / retained earnings) account for the particular fiscal year. Use the Import Net Changes function for this. Do not import the period net changes as the Import Batches / Transactions functions will do this for you.

The Consolidate Posted Transactions function (from the Maintenance menu) is used to save disk space and merge detailed posted transactions into a single record. You can choose to group and merge transactions for the same account / department / period or for the same account / dept / period / source code. You save disk space, but the Detail Listing report and financial report drill-down become less interesting as you lose individual detail amounts, references and descriptions. This function can be run for particular accounts, so it is not an all-or-none proposition.