Uploading Bank Transactions

Transactions are created automatically when your bank feed is synced, but you’ll need to upload transactions manually if your bank isn’t available for a direct integration. Doing so is simple -- just follow the directions in this article.

First, navigate to your cash reconciliation page and select a bank account. You can find your chosen account by using the All Accounts search bar in the top left corner of your screen.

Once you’ve chosen an account, you’ll see a button appear in the upper middle part of your screen labeled Upload Transaction. Click this button.

In order to upload a transaction, you’ll need to use a template provided for you by Rillet. You can download this template by clicking the Download Template button.

When you open the template, you’ll see a number of required fields. Here’s what each of those fields are and what they mean:

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

The External Transaction ID is a very important unique identifier which can be used to override previously uploaded information. It's important to ensure you don't re-use previously uploaded IDs.

Once you’ve filled out at least the required fields, you can reupload the template with your edits. It’s recommended that you save a copy of the template to make updates to your original upload as needed.

After clicking the Upload button, your transaction will appear in your bank feed, and you’re all set!