Match Transactions

Related topics

About Sage Bank Feeds

Import a bank statement

Reconcile an account

Print an imported transactions report

In the Match Transactions window, you can match transactions automatically or manually.

To begin matching transactions:

  1. Open the Match Transactions window.
    ClosedHow?
    1. In the Home window, click Banking on the navigation pane.
    2. In the Tasks pane, click the Match Bank Transactions icon.
    3. Select Match Transactions.

      4. Note: You can also open the Match Transactions window by importing a bank statement by choosing Import/Export from the File menu and then Import Online Statements.

  2. Select the transactions you want to see. You can choose unmatched transactions, matched transactions, or all transactions.

    Note: If you want to change the Sage 50 Account, transaction period, or transaction type, you can use the filter options.

    3. ClosedTo match transactions automatically
    1. From the Use this Sage 50 account to auto match transactions menu, select a Sage 50 account to use for automatic matching.
    2. Click Auto Match .
    ClosedTo match transactions manually
    1. Click Find Match beside a bank transaction to open the Find Matching Transactions window to manually match transactions. For reference, you can see the bank transaction at the top of the window.
    2. (Optional) The Sage 50 account selected in the previous window is used by default. Select a different Sage 50 account, if necessary.
    3. (Optional) By default, you see the Sage 50 transactions within the 30-day period prior to the transaction date. You can adjust the dates.

      Note: The transaction date must be within the earliest year of financial history to end of next year.

    4. Select the transactions you want to see in the Show menu. You can choose all unmatched transactions of the same amount, all transactions of the same amount, all unmatched transactions, or all transactions.
    5. Select the corresponding transaction by clicking in the check mark column.
    6. Click OK.

      7. Note: Transactions are indicated as either Auto or Manual for the current session. After you click Save, their status becomes Matched.

  3. Click Save.

    4. Notes: To undo a matched transaction, open the menu in the Action column and select Remove Match.

    When you close the Match Transactions window, if you have selected the option to open the Reconciliation and Deposits window automatically, that window opens so you can reconcile accounts .

To create a new transaction for bank or credit card transactions or to transfer funds

Similar to adjusting entries during account reconciliation, you can use the Create Transaction option to create a new transaction or transfer funds in Sage 50.

ClosedBank—Money-In Transactions
ClosedTo create a transaction for bank interest
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Bank Interest and enter the transaction details.
  3. Click Process.
ClosedTo create a funds transfer
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Bank Transfer and enter the transaction details.
  3. Click Process.
ClosedTo create a sales invoice
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Sales Invoice and enter the transaction details.
  3. Click Process.
ClosedTo create a sales receipt
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Receipt and enter the transaction details.
  3. Click Process.
ClosedTo create a general journal transaction
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select General Journal and enter the transaction details.
  3. Click Process.
ClosedCredit Card—Money-In Transactions
ClosedTo create a transaction for credit card cash back or refund
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Cash Back and Refund and enter the transaction details.
  3. Click Process.
ClosedTo create a funds transfer
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Bank Transfer and enter the transaction details.
  3. Click Process.
ClosedTo create a transaction for a credit card payment
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Pay Credit Card Bill and enter the transaction details.
  3. Click Process.
ClosedTo create a general journal transaction
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select General Journal and enter the transaction details.
  3. Click Process.
ClosedBank—Money-Out Transactions
ClosedTo create a transaction for bank fees or charges
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Bank Charges and enter the transaction details.
  3. Click Process.
ClosedTo create a transaction for a funds transfer
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Bank Transfer and enter the transaction details.
  3. Click Process.
ClosedTo create a purchase invoice for a transaction
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Purchase Invoice and enter the transaction details.
  3. Click Process.
ClosedTo create a transaction for a purchase invoice payment
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Pay Purchase Invoices and enter the transaction details.
  3. Click Process.
ClosedTo create a transaction for a payment without a purchase invoice
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Make Other Payment and enter the transaction details.
  3. Click Process.
ClosedTo create a transaction for a credit card payment
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Pay Credit Card Bill and enter the transaction details.
  3. Click Process.
ClosedTo create a general journal transaction
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select General Journal and enter the transaction details.
  3. Click Process.
ClosedCredit Card—Money-Out Transactions
ClosedTo create a transaction for bank fees or charges
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Bank Charges and enter the transaction details.
  3. Click Process.
ClosedTo create a transaction for a funds transfer
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Bank Transfer and enter the transaction details.
  3. Click Process.
ClosedTo create a purchase invoice for a transaction
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Purchase Invoice and enter the transaction details.
  3. Click Process.
ClosedTo create a transaction for a purchase invoice payment
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Pay Purchase Invoices and enter the transaction details.
  3. Click Process.
ClosedTo create a transaction for a payment without a purchase invoice
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select Make Other Payment and enter the transaction details.
  3. Click Process.
ClosedTo create a general journal transaction
  1. Beside the imported transaction, open the menu in the Action column and select Create Transaction.
  2. Select General Journal and enter the transaction details.
  3. Click Process.

Published: June 12, 2018
© 2018 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks