Importing and Exporting Transactions

You can import bank transaction batches created in non-Sage 300cloud programs and in remote Sage 300cloud sub-ledgers into Cashbook for Sage 300cloud.

Cashbook treats imported batches as regular batches.

Note: To see exactly how to format records for importing, we suggest that you first export records from the sample data that comes with Cashbook, specifying the format in which you plan to import.

You can also export transaction batches from Cashbook to other programs. For example, you could export data to a spreadsheet for analysis. You can also export batches of recurring transactions to import later.

Note: Cashbook creates export files for Microsoft Excel.

To display a list of the fields you can import and export:

  1. Open the record or transaction entry screen for the type of record or transaction you want to import or export.

  1. For screens with a Batch Number field, specify a batch.

  1. Click Options > Import or Export.

  1. If a File Import/Export Selection screen appears (for example, if you clicked Import or Export on the Customers screen), select the type of record to import or export, and then click OK.

  1. On the Export screen that appears, expand and review fields available for import and export.