Importing transactions using a Generic CSV File

Sometimes you may want to import bulk payments using a csv file.  If you don't have a bank format setup within Chintaro to import payments, you may just want to create and import a generic file.  This solution outlines that process.

TABLE OF CONTENTS

• Create Generic CSV File
• Setup Bank File in Chintaro
• Import File

Create Generic CSV File

To create a generic csv file, open Excel and create a csv file that has no header row, and only 3 columns, which must be in the following order:

Date, Amount, Payment Book ID

Eg: 

Alternatively, it can be created using Notepad with commas to separate the fields:

Setup Bank File in Chintaro

1. Login to Chintaro
2. System Maintenance > Reference Tables > Bank Account
3. Add an entry with a new account name (eg Generic CSV), and BankFormatID Generic CSV

Import File

Import the transactions in the file following the instructions in this solution: Finance - Importing Bank Statements

This will create an entry for the bank file which can be used for reporting, as well as create a tenancy transaction.