Import from CSV

This option is listed in the Processing menu.

 

Typical applications of this function include the following

 

Financial Year End entries are easily generated from Income and Expense reports and can conveniently update all affected accounts through a single import. Use Journal type “BJA”

 

Bad Debt reversals can easily be managed with type “BDX”. Debit the Bad Debt account and credit the relevant client account.

 

Off line users can maintain spreadsheets with information, such as Fees which can then be conveniently imported into the system. For Fees use type “BFA”

 

Recoverable Disbursements may be captured manually or loaded from monitoring software, such as telephone or copier solutions. Use Journal type “BJA” or Petty Cash “BPC”

 

The various transaction types are all ledger based and it is not possible to update a Cash Book using this import.

 

The Processing: Import from CSV menu item allows the direct processing of transactions from a pre-formatted, prepared CSV file.

The file must follow a layout similar to this:
BookType, Matter1, Business2, Description1, Description2, Date, Amount, VAT, Voucher

BookType Users familiar with import of batch transactions in any suite of legal software should be comfortable with this type of file and layout.

Contains a valid transaction type. Only Ledger type transactions are support. Bank transactions such as receipts and cheques cannot be processed here.
Valid options are
BJA – Business Journals
BFA – Business Fees
BFX – Business Fee Reversals
BDX – Business Credit Notes
BPC – Business Petty Cash
BBF – Business Balance Brought Forward
TJA – Trust journals

Matter1
An existing ledger account number. The account to be debited.

Business2
An existing ledger account number. The account to be credited.

Description1
Transaction narrative for the account to be debited.

Description2
Transaction narrative for the account to be credited.

Date
A valid date in yyyy-mm-dd format.

Amount
A valid transaction amount. 0.00 transactions are not processed.

VAT
Contains a valid VAT type.
Valid options are
N*0 – No VAT
I*10.00 – Input VAT at 10%
O*17.5 – Output VAT at 17.5%

Voucher
Optional. If blank will be replaced with the word “Import”

 

Business Balance Brought Forward BBF types are suitable for bringing forward balances from third party accounting records.

 

Dynamic