Finance - Creating your own Bank file for importing payments

Modified on Tue, 06 Sep 2022 at 01: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 DateA valid date which will be used as the transaction date when the payment is created in Chintaro.
Column 2Txn AmountA positive number, expressed as a currency. The total amount of the payment.
Column 3DescriptionThis 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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article