fbpx

Import Journals CSV

Import Journals via CSV file into KashFlow. Just map your spread sheet to our template and make sure you include all the required columns below. The Journal must balance otherwise the import will fail. Before importing a Journal you need to ensure you have the Nominal Codes the Journal will use exist within the KashFlow account.

Please ensure you have enabled Journals before you import your CSV.

Download This Template

Required Fields

The Journal import requires four fields;

  • Journal Number – this is the identification number of the Journal – it must be a number – i.e. “1”
  • Date – this is the date that the journal is dated, it must be in DD/MM/YYYY format – i.e. “01/01/2015”
  • Line Amount – this is the amount to be credited or debited, to credit an amount make it a negative, it must be a number to a maximum of two decimal places – i.e. “-40.00”
  • Type Name/Nominal Code – this is the code to be debited or credited and must be defined in your Chart of Accounts (accessible at Settings > Chart of Accounts) – i.e. “4001” or “Sale of Goods”

Optional Fields

The other fields you can have are listed below, along with a description, how it should be formatted and example text:

  • Journal Comment – this can be a description of your journal – i.e. “Year End 2010”
  • Narrative/Journal Line Comment – this can be a description of your credit or debit – i.e. “Electric Bill”

Uploading the template

To import

Settings > Import Data > Import CSV Files > Enter in your Username & Password (Please note if you have specified an alternative API Password you would need to use it here) > CSV > Journal Entry > Upload your file > Tick the box ‘ My first row contains column headings; if appropriate Use the drop downs to map the file > Import

Please note, if the CSV file contains any special characters such as, ‘ ; ( ) {} & * £ $ “ ” <> ? / @ ~ # etc… Please remove as these may cause errors to the import process. 

Screen-Shot-2012-12-29-at-19.13.27

Download This Template

See how KashFlow works with your business and your books