Bank Feeds Matching

How Bank Feeds Work

Saasu connects to your bank and loads new transactions into your Inbox. Saasu also suggests transactions (blue suggestions) in your Saasu file that match data in your bank feed. You can tick these using the icon provided if it looks correct. If no suggestions exist you can create (plus icon) or search (magnifying glass) for transactions easily from this area until you clear your inbox. Watch VIDEO to Learn more

How to Edit Bank Feed Items summary/description

  1. Click the summary (highlighted in yellow when you hover) for each bank feed item to change it to something more meaningful for you. The edited summary will be used when creating Saasu transactions from the bank feed item.
  2. Click the Revert link that displays beside the modified summaries to reset them to the original bank summary.

Matching Bank Feed Items with Saasu Suggestions

When possible, Saasu will suggest existing transactions in your file which may be matches for your bank feed items. These will display below each of your bank feed items in blue.

  1. To accept a suggestion, click the Acceptbutton that displays when you hover to the right of the suggestion.
    • When you accept a Bank Transfer, Purchase Payment, or Sale Payment suggestion:
      Saasu matches the bank feed item with the existing bank transfer, purchase payment, or sale payment.
    • When you accept a Sale or Purchase suggestion:
      Saasu creates the sale/purchase payment transaction using the details of the bank feed item, and matches the bank feed item with the new sale/purchase payment.
  2. To view/edit the suggested transaction, click the Edit button that displays when you hover on the right.

Matching Bank Feed items with Existing Transactions

If there are no suggestions for a bank feed item, or none of the suggested transactions match, you can search for other existing transactions in your file to match with the bank feed item.

  1. Click the Search button to the right of the bank feed item and choose the transaction type to search for (eg Unpaid Sales) – This will replace the suggestions list with the Match with… dialog.
  2. Search/refine the results within the dialog using the available filters.
  3. Once you’ve found the transaction/s, select these and click the Match against selected button.
  4. You can view/edit the transactions by clicking the Edit icon to the right of the row.

Matching by Creating Transactions from Bank Feed Items

If a bank feed item does not match any existing transactions, you can create new transactions using the bank feed item details.

  1. Select one or more bank feed items.
    • Click an individual feed item (or its checkbox) to select/deselect it.
    • Click the checkbox in the header bar to bulk-select/deselect the feed items on the screen.
  2. Select the transaction type from the Create As menu.
  3. Complete the required/relevant fields.
  4. Click the Submitbutton to e.g. Create Service Sales with Payments from the selected bank feed items – Saasu will create transactions using the combined information from the bank feed item (date, amount, summary) and the form fields (account, tax code, contact, tags, etc). It will then match the bank feed items with the newly created transactions.

Matching Multiple Transactions from Bank Feed

NOTE: The steps below can apply to transactions such as sales and/or purchases. The example below shows for a sale transaction.

Allocating single bank feed item to multiple sale payments

  1. Go back to Automate > Bank Feed
  2. Select the magnifier icon >> Click “Sale Payment”.
  3. Click “Match against selected”
  4. Use the left hand checkboxes to select each of the payments to match against the bank feed transaction. The total of the selected payments must match the total of the bank feed item.
  5. Click “Match against selected”.

You can match up to 25 payments to a single bank feed transaction at any one time.

Note: You can only match multiple payments to a single bank feed item in the base currency of your file (eg. if you have an Australian file then the multiple payments you match must all be AUD). If you have a mix of base currency and foreign currency transactions to match then this will need to be handled via a clearing account.

Allocating a single bank feed item for unpaid transactions

  1. Go to Automate > Bank Feed
  2. Select the magnifier icon > click “Unpaid Sales”. A list of unpaid sales is shown where you are able to select multiple sales and apply payment against it.
  3. Click “Match against selected”.

Unmatching Bank Feed Items

  1. From the Matched or Allview, select the bank feed items to unmatch.
  2. Click the Unmatch action link above the header bar.
  3. Alternatively, you can unmatch bank feed items individually by clicking the Unmatch button for each feed item.

IMPORTANT: Unmatching a bank feed item does not delete the Saasu transaction that the bank feed item was matched with. You may need to locate the Saasu transaction (i.e. the sale, purchase or bank transfer the bank feed item was matched with) separately and delete/reverse it if necessary.

Deleting Bank Feed Items

  1. Select the bank feed items to delete.
  2. Click on the Delete action link above the header bar.

NOTE: You can only delete unmatched bank feed items. To delete a matched item, you will need to first unmatch the feed item and then delete it. Once you delete a bank feed item it will be moved to the Deleted folder.

Un-deleting Deleted Bank Feed Items

If you realise you deleted a bank feed entry in error, this is how to Un-delete the deleted bank feed entry and move it back to ‘Inbox’.

  1. Go to Automate > Bank feeds.
  2. From ‘Inbox’ drop down to ‘Deleted’, select the bank account. This will list all the bank transactions deleted under the bank account.
  3. To un-delete select ‘Undelete this transaction’. This bank transaction will appear in your bank feeds ‘inbox’.

Multiple Pays in a Pay Run

Matching Group Payroll transactions is one of the last items we need to handle in bank feeds. Apologies that we don’t support this yet. What you can do is leave it in your inbox until we release the matching feature soon or else add a journal transaction in which you allocate to the same Bank account to match it.

Foreign Currency Bank Feed Matching

With multi-currency plans you can also use the Bank Feed service to match your foreign currency payments.

  1. Create your foreign currency invoice. In our example we will use USD 299.00 (which converts to AUD 318.22):

    Note: XE.COM has been unchecked, because we are using our own conversion rate.
  2. Make sure the date of the invoice is on or before the date the transaction appears in your bank statement/feed.Then go to your. Bank Feeds section and locate the entry to be matched. Click on the ‘AUD’ field and select the correct currency:
  3. Enter the foreign currency amount and hit enter. You should find that a suggestion will automatically appear. Simply click on the tick to reconcile.

Note: This is for foreign currency invoices without a payment already applied (whether manually or via a previous instance in Bank Feeds). You can only download foreign currency transactions from local Bank Accounts, and not foreign bank accounts. E.g. your base file currency is in AUD and you have two different bank accounts – one in AUD, one in USD. You can download data from your AUD bank account but not your USD bank account.