<< Click to Display Table of Contents >> Navigation:  How do I......... > General....... > Import data and create batches

This utility allows for the direct importing of information contained in a spreadsheet, into the system which creates unposted batches, units or budgets, and an import report.  It allows for the preparation of your information while offline, and then its uploading when connected to the system.

 

The information for each of the supported imports/batch types must be organised in accordance with the template examples shown below.

 

The batch import facility covers the following batches:

 

1. Property Sundry Payment Batch

2. Property Creditors Journal Batch

3. Unit Journal Batch

4. Agent to Unit Journal Batch.

5. Unit Electricity Batch

6. Unit Receipt Batch

7. Property GL Journal

8. Property Sundry Receipt Batch

9.  Deposit Interest Journal

10.Budgets (Property and Agent)

11.Agent Sundry Receipt Batch

12.Unallocated Unit Receipt Batch

13.Unit - Create new units and import data

14.Legal Fee Creditors Journal with Unit Recovery

15.Unit Refund Batch

16.Agent Creditors Journal Batch

17.Agent Sundry Payment Batch - Central Banking

18.Agent Sundry Payment Batch - Business Banking

19.Agent to Property Adjustment Batch (Fees to a Property)

20.Unit Deposit Journal Batch

 

 

The imported information will be validated according the the validation rules contained in the system input screens relevant to each batch type.  Some of the user input that is required when using the system input screens, will be defaulted when using this import facility.  Details of these defaults can be found by clicking on the relevant batch type listed above, and should be considered before using this facility.

 

Click here to view a brief tutorial on using the facility.

 

 

NB. Please note date format.  If values with decimals are imported, the decimals will be removed in the import process.