Bank Transactions display the feed of transactions from a linked or custom Bank Account (done previously on the Bank Accounts tab). Convert Bank Transactions into Journal Entries or Cash Receipts from this page.

Under Cash Management>Bank Transactions, select the Bank Account to review (only banks with a linked SoftLedger Ledger Account will be available to select from the dropdown list). Once selected, the month to date transactions for the Bank Account will appear in the below table.

The above table will display the information for the Bank Transactions such as the Description, Date. Category, and Amount. This information comes directly from the linked bank if coming from Plaid, or the bank transaction uploads for custom banks.

For Custom banks, users can delete bank transactions within the bank transaction table for the that bank by selecting one or more checkboxes next to each transaction and clicking the Delete Transaction button:
​

If looking to delete a set of bank transactions from a particular upload in bulk, you can always find the ID from the transaction upload page to then filter on the bank transactions themselves to find the set from that upload for deletion. See more on that type of process in the editing journals from a bulk upload article-->

If there are transactions that have come through your feed, you can hide them so they do not appear in your standard bank feed without assigning a journal entry against that transaction. Select the transaction(s) from the checkbox at left of the transaction and then click the Hide Transaction icon.

Once hidden, you can review the hidden transactions from the Cash Management<Bank Transactions page and toggle ON the Show Hidden button. Click the Unhide on the transaction to return that transaction to the standard feed for coding as usual.

Similar to hiding, if you have bank transaction lines that are already accounted for, but you do not wish to link to an existing journal entry (but do want a checkmark next to the line), then you can mark the bank transaction line as reviewed.

The option to mark as reviewed comes only from the bulk edit options available when checking a checkbox next to one or more bank transaction lines:

Once lines are marked as reviewed, they will have a checkmark like other lines already accounted for. If you wish to return a bank transaction line to be available for actions once again, you can mark one or more lines as unreviewed in bulk as well:

Bank Transactions are booked into Journal Entries from the Actions column or through bulk action by clicking the checkbox(es) at left of each row in the table.

The Journal Entry will auto populate detail from the bank transaction, such as Dates, Reference, Debit/Credit, and Description

See a table below of field mapping between bank transaction to journal entry:

If there is an existing journal line that could be a suitable match for the line, a + icon will show. Click this to view potential matches and link them.

A Journal Line will be considered a possible match, if ALL of the criteria below are true:

The Transaction Match Tolerance sets how much a Journal Line amount can differ from the bank line amount and still be offered as a match. The value is a percentage of the bank line amount, from 0 to 50. At 0 (the initial value), only an exact amount matches.

For example, with a tolerance of 2 and a bank line of 1,000.00, Journal Lines from 980.00 to 1,020.00 are matches. This is useful for absorbing wire fees and small FX differences that would otherwise block a match.

Set the default for your whole tenant under Settings > System > Payment & Cash > Default Transaction Match Tolerance %.

To use a different value for one bank account, set Transaction Match Tolerance % on the Edit Bank Account form; clear it to return to the system default. The bank account view shows which value applies, with (system default) shown when the account has no value of its own.

Potential matches are listed with the smallest Amount Difference first (ties go to the later transaction date), up to 25 Journal Lines. The Amount Difference column shows Exact when the amounts are equal, or +/- the difference when the Journal Line is larger or smaller than the bank line.

When a row has a linked journal line, the actions column will show a check at the left. You may click on this check button to view the linked journal entry.

When money comes into a bank account, it could be the receipt of cash for an outstanding AR Invoice. If a bank line matches the below criteria, the option to create a Cash Receipt (which can later be applied an outstanding AR Invoice) will be visible:

The following fields will be populated

Use a Direct AR Payment when a customer paid a single Invoice and you don't need a Cash Receipt. Click Create AR Payment on the bank line, then turn on the Direct AR Payment toggle. The option is available when:

Select the Invoice the payment applies to and submit. Only unpaid Invoices in the bank line's currency are listed. The payment is applied to the Invoice (marking it paid or partially paid), and the payment journal is linked to the bank line. Voiding or deleting the payment later removes the link from the bank line.

When money leaves a bank account, it could be for the payment of an outstanding AP Bill. If a bank line matches the below criteria, the option to create a Bill Payment will be visible:

You can create the Bill Payment under the Actions section by clicking the credit card icon:

Then select which Bill the payment is for:

When submitted, the bank transaction line then reads with a checkmark and ability to view the payment:

If many of the same lines can be posted to the same Ledger Account, you can select all of those lines and create the journals in bulk. Utilize the Filters at top to find the same types of bank transaction lines (e.g. Search under Description for "Uber"). Once you have selected the desired Bank Transaction lines, click "Create Journal":

When creating the Journal Entry(ies), you are able to determine the corresponding Ledger Account, Cost Center (or other Dimensions), Customer/Vendor, and Reference field. For each Journal Entry, the details will be added from the Bank Transaction as explained in the Booking Journal Entries section above.

In this same bulk manner, you can select any Journal Entries to delete if you have found that there were errors made, and an update to the Journal Entry(ies) is required:

Once you have completed your bank transaction feeds for a period, the Journal Entries produced from a Bank Transaction will automatically have a Reconciled flag against them when viewing in the Statement in the Reconcile section. Review the knowledge base article on Reconciliation-->