By importing your bank account statement as a .CSV file, Roger lets you easily match transactions listed on your bank account with bills or receipts in Roger to help you prepare for bank reconciliation.
You can also upload a missing document or appoint the responsible coworker to acquire and upload the document.
And if the corresponding document has simply gone missing, you can either ignore the transaction altogether or add it to Inbox to help you keep an overview of the missing document.
All documents will be synced to your accounting platform thanks to Roger's integrations, hereby ensuring consistency between your bank account and your accounting platform.
How to submit a bank account statement
1. First, click Document match in the left-side menu. This takes you to the main area for document matching:
2. Click anywhere on the empty page, or click the Import button in the upper right corner to import a bank statement. This opens a window that lets you upload the bank statement. Click Choose file to locate the .CSV file on your computer:
3. After selecting the desired file, Roger will show you a preview of the data taken from the file.
- If you like, you can select a payment source for all transactions by using the dropdown menu at the top.
You must now map each column in the .CSV file with a parameter in Roger: date, amount, description and currency. In addition, you can check the box Has Header Row to tell Roger that the first row in the .CSV file contains the header of each column and not data.
When you have made sure that everything is good, click Import to start the import itself.
- FYI: If relevant, click the pencil icon next to Amount to change whether your .CSV file uses a comma decimal separator or a period decimal separator.
How to match transactions with documents
1. After importing a bank account statement, Roger tries to match all transactions in the statement with bills and receipts already existing in Roger. You will automatically see an overview of the results of this when the .CSV file has been imported:
- Roger analyzes information such as amount, date, and vendor name to automatically attempt to match transactions with documents.
2. In this example, none of the transactions were matched. Therefore, all transactions are now visible in the Document Match menu in the Unmatched tab as
- Had Roger been able to match any of the transactions, they would be visible in the Matched tab.
3. You now have four options to process the unmatched transactions, shown in the right side of each transaction under the Quick actions header: Attach document, Manually match, Generate document and Ignore transaction:
Clicking on this icon will give you three options:
This option lets you assign a coworker to upload a document for the transaction. After assigning a coworker, the coworker will see the transaction in their own account under Document match > Assigned and will have to decide how to obtain a document for that transaction:
This option lets you upload a document for the transation from your computer. You also have the option to select whether to upload a receipt or a bill. This will change the transaction's status to
Matched and move it to the Matched tab.
This option lets you create a workflow that can perform automatic actions for future bank transactions. Specifically, you can create workflows that either 1) automatically assigns a coworker to upload a document for a transaction or 2) automatically generates a receipt for a transaction, so you and your coworkers won't have to do it manually.
- FYI! If you create a workflow to handle bank statements, the workflow can be found together with your other workflows in Workflow.
Clicking on this icon will enable you to match an existing document in Roger with the transaction. This opens a window where you can select from existing documents in Roger. When you have selected a document, the transaction's status will change to
Matched, and the transaction will be moved to the Matched tab.
Add to Inbox
Click this icon if a transaction is missing a document. Roger will instead add the transaction without a document to your company's Inbox to help you maintain overview of transactions missing a document. Clicking the icon will open a new window in which you must confirm the amount, date, and vendor of the transaction. You can also add a note to the transaction that will be visible in Inbox. After adding the transaction, its status will change to
Matched, and you will be able to find it as an entry among your documents in Inbox.
Click here if you do not want to match any document with the transaction. You must then provide a reason for processing this transaction without a document. This will change the transaction's status to
Matched and move it to the Matched tab.
- Do you want to restore an ignored transaction? First, locate the transaction in the Matched tab, and click the transaction's status
No document. This opens a new window where you can read the reason why the transaction was ignored. Click Delete to restore the transaction and send it to the Unmatched tab: