Transaction Lines

Downloads a selection or all of your Exact Online general ledger transaction lines as an Excel workbook from one or more Exact Online companies.

Parameters

The following parameters can be specified:

•Exact Online company division code to be downloaded. When empty, all accessible Exact Online companies will be downloaded.

•Financial year from; when specified only include transaction lines with a financial year equal to or later than the specified value.

•Financial year through; when specified only include transaction lines with a financial year smaller than the specified value.

•General Ledger account code pattern; only include transaction lines whose General Ledger account code matches the specified pattern.

•Project code pattern; only include transaction lines whose project code matches the specified pattern.

•Item code pattern; only include transaction lines whose item code matches the specified pattern.

•Account name pattern; only include transaction lines whose account name matches the specified pattern.

Excel Output Format

The Excel workbook has three worksheets:

•Number of companies selected.

•Parameters and their values.

•Transaction lines.