Import Internal Charges

Importing internal charges allows you to import internal charge transactions from an external CSV file into Arbor Finance. This can be useful if you have multiple internal charges to process at any one time and can save re-entering similar details.

File format for Importing

The CSV file should be structured as follows:

1. Column 1 is the Is transfer from: enter Y or N depending on if transferring from the budget
2. Column 2 is the Date
3. Column 3 is the Budget code
4. Column 4 is the Analysis code
5. Columns 5 is the Amount
6. Column 6 is the Reference
7. Columns 7 is the Description
8. Column 8 is the Funding stream
9. Column 9 is the cost centre

Please check the structure before importing.

Importing Internal charges

1. From the Transactions menu choose Internal charges > Search/Process
2. Click the Import button on the right-hand side
   
   
   
   
3. To select your file to import click Choose file and navigate to the file and click Open.
4. The Header line defines which line in your CSV file the headers are on. Select a header line and click 'Next' to continue.
5. Map the headers in your CSV document to the analysis fields and type the mapping name for future use of this mapping.
6. If you are uploading the file for a second or third time and have a mapping stored then select it from the menu.
   Note:- only map the fields you want to import, you do not have to do them all!
7. Click Save to continue.
   
   
   
   
8. The Validation summary will detail if any lines have errors in. The summary report will detail the errors (blue link on page to access this).
9. If you need to change anything click Cancel or click Complete import to proceed.
10. For those lines that are valid they will be imported and you will see the completed successfully message as per below: