Upload Bank Transactions
Transactions are created automatically when your bank feed is synced. If your bank doesn’t support direct integration, you can manually upload transactions into Rillet using a preformatted template. This ensures your financial records remain complete and accurate.
Uploading Transactions Manually
Follow these steps to manually upload your bank transactions:
Go to the Cash Reconciliation page.
From the All Accounts search bar (top left), select a bank account.
Click Upload Transaction in the upper middle section of the page.
Select a transaction format and click Continue.
Click Download Template to get the Rillet upload file.
Fill in the required fields in the template (see field descriptions below) and click save to completed file.
Click Select File in Rillet.
Click Upload.
Your transactions will now appear in the bank feed.
Required and Optional Fields
The Rillet upload template includes several fields that define each transaction. Make sure you complete all required fields before uploading. Optional fields can be used to provide additional transaction details for more accurate reporting.
Field Header
Required?
Description
Amount
Yes
The amount of the transaction. This is positive for cash receipts and negative for cash payments.
Balance
No
The balance of the account after the transaction. This is helpful in automated cash reconciliation
Currency
Yes
The currency your transaction. This must be the same as the bank account currency
Date
Yes
The date of the transaction. Supported formats are MM/DD/YYYY, MM/DD/YY or YYYY-MM-DD
Description
Yes
A description of the transaction. This will be visible in your bank feed
External Account ID
Yes
The account number
External Transaction ID
Yes
The transaction ID number. This must be a unique transaction ID even across multiple uploads. This ID can be used to override previous upload information too
Merchant
No
The merchant associated with your transaction. This field will appear on your bank feed
Notes:
The External Transaction ID is a unique identifier. Never reuse IDs, even across multiple uploads.
To correct an uploaded transaction, use the same External Transaction ID to override previous data.
Save a copy of your completed template to simplify future updates or corrections.
See Also
To learn more about managing your bank feeds and reconciliations in Rillet, review these articles:
Last updated