Finance - Creating your own Bank file for importing payments

Modified on Tue, 6 Sep, 2022 at 1:34 PM

If your tenant's payments are being received into a system other than Chintaro, you might need to have a file created from those payments, so that it can be imported into Chintaro, as a normal bank statement would be.

You will need to have the file created as a CSV file, with the following columns:

Column 1	Txn Date	A valid date which will be used as the transaction date when the payment is created in Chintaro.
Column 2	Txn Amount	A positive number, expressed as a currency. The total amount of the payment.
Column 3	Description	This should contain the description of the transaction. If you are matching these payments against the payment book field on the Tenancy, use the Payment book reference here.

Example:

01/11/2020, 135.00, 0029, Payment made by Bruce Springbean

01/11/2020, 150.00, Payment made by Fred Springstone 0045

Notes:

There are no apostrophes used to contain the columns.

There is no header row.

You can add more columns to the file, but anything after the third column will be ignored.

In the example above, the first row will match with Bruce Springbean who has a Payment book ID of 0029.

Fred Springstone has a payment book ID of 0045 but because there is more than just 0045 in the string, he will not match.