For example:
- Importing a set of journal entries that the amount can vary each month. (Example: Utility or Telephone bills)
- Importing a set of monthly expenses that are recorded through a journal entry and the amount is the same each month. (Example: Rent)
- Importing a long list of journal entries sent to you by your outside accountant (via a spreadsheet).
Setup
Location: Tools – Control - Mappings
Creating a mapping will allow you to indicate which columns of a CSV file contains specific journal entry details. If the same layout is used each time this mapping will only need to be created once. If multiple CSV layouts are going to be used, multiple mappings may be needed.
Using the first two columns of example data provided in the mapping window, indicate which columns on the spreadsheet should populate the fields on the Journal Entry window.
For example: the column containing 960 represents an Account Number, the column containing "Online Store Fees" represents a memo, the column containing $360.45 represents a Debit Amount and the column titled "Credit" that does not contain a value represents a Credit Amount.
Go to Accounting - General Ledger – New and within the Journal Entry window click Import.