Bank Reverse Transactions Screen
Click this button to update the bank account balance, and send the reversal information to the subledger.
Click this button to reverse all the transactions displayed on the detail table.
Note: This button appears only if you select the Reverse Multiple Transactions option.
After you enter a bank code, this field displays the bank account number specified in the bank record.
If you use multicurrency accounting, the statement currency specified for the bank is displayed in a field to the right.
Use the Finder or the navigation buttons to select the code for the bank that processed transaction you are now reversing.
The default bank code specified on the Bank Options screen appears when you open the screen, but you can change the code if you are reversing a transaction that was processed to a different bank.
Once you specify the bank code, the program displays the bank account number from the bank record.
This field appears if you are reversing a bank entry processed in Bank Services.
The program displays the amount of the transaction. You cannot change it.
This field appears if you are reversing a bank entry, and displays the date that the entry was posted. You cannot change this date.
This field appears if you select Bank Services as the source application.
If you are reversing a single bank entry, enter the number for the bank entry you are reversing.
Tip: If Accounts Receivable, Accounts Payable, or Payroll sent a selected transaction to Bank Services, you can click the Drilldown button to view the document in the source application.
This field appears if you select Accounts Payable as the source application, allowing you to reverse vendor payments, customer refunds, or payroll checks.
If you are reversing a single payment, use the Finder to select the check or payment number.
Tip: If Accounts Receivable, Accounts Payable, or Payroll sent a selected transaction to Bank Services, you can click the Drilldown button to view the document in the source application.
This field appears if you select Accounts Receivable as the source application.
If you are reversing a single check, use the Finder to select the customer's check number or cleared receipt number.
Tip: If Accounts Receivable, Accounts Payable, or Payroll sent a selected transaction to Bank Services, you can click the Drilldown button to view the document in the source application.
This field appears if you selected Accounts Receivable as the source application.
If you are reversing a single check, enter the code for the Accounts Receivable customer whose check was returned NSF.
This field appears if you selected Payroll as the source application.
If you are reversing a single transaction, enter the code for the US or Canadian Payroll employee whose check you are reversing.
This field appears if you are reversing an Accounts Payable or a Payroll payment, or an Accounts Receivable refund.
The program displays the amount of the transaction. You cannot change it.
The program displays the date that the payment or refund was issued in the source application.
Enter the reason you are reversing the transaction.
This field appears if you are reversing an Accounts Receivable receipt.
The program displays the amount of the transaction. You cannot change it.
The program displays the date of the receipt you are reversing.
The session date appears as the default date for this field.
The reversal date determines the year and period to which the reversal is posted. (The year and period are displayed in the field to the right.)
If you are reversing a paycheck generated in Canadian Payroll or US Payroll:
- The Reversal date may be used to reverse the paycheck and update the associated employee record in Payroll, depending on certain options set in that program.
-
There can be significant tax consequences associated with the reversal date. Before accepting or changing the reversal date, consider the following points carefully:
- If Payroll is not configured to use original dates when reversing checks, the journal entries for the reversed check and the employee's payroll data will use the reversal date you enter.
For a Canadian Payroll check, we recommend that you enter the original check's Pay Period End Date as the reversal date.
- If Payroll is configured to use original dates when reversing checks, the journal entries for the reversed check and the employee's payroll data will use the original check dates, regardless of the date you enter in this field.
- If Payroll is not configured to use original dates when reversing checks, the journal entries for the reversed check and the employee's payroll data will use the reversal date you enter.
This field is available if you selected Accounts Receivable or Bank Services as the source application.
Specify the type of transaction you want to reverse: payments, deposits, or receipts.
The entry in this field determines the type of document you can select for reversal.
If you are reversing a miscellaneous receipt for an Accounts Receivable customer or a miscellaneous payment for an Accounts Payable vendor, you can select this option to reverse the associated invoice automatically when you post the reversal.
Note: If the miscellaneous receipt or payment was for a customer or vendor with no record in Sage 300, Bank Services automatically reverses the invoice when you post the reversal. (You cannot choose whether to reverse the invoice.)
Double-click in the Reverse Invoice column for a selected transaction.
Select this option to reverse a range of transactions.
When you select this option, additional fields appear on the screen, allowing you to reverse more than one transaction. More...
Specify the program where the transaction originated: Accounts Receivable, Accounts Payable, Payroll, Bank Services, or Other Application.
This field appears if you specified Accounts Payable as the source application.
If you are reversing a single payment, enter the code for the Accounts Payable vendor.
This field displays the bank entry numbers for the selected withdrawals and deposits.
Tip: To drill down to an original entry, select a transaction on the detail table, and then click the Bank Entry Number column heading.
This field displays the check numbers for the selected payments.
Tip: To drill down to an original entry, select a transaction on the detail table, and then click the Check/Payment No. column heading.
This field displays the check and receipt numbers for the selected payments and receipts.
Tip: To drill down to an original entry, select a transaction on the detail table, and then click the Check/Receipt No. column heading.
Enter the reason you are reversing the transaction.
The session date appears as the default date for this field.
The reversal date determines the year and period to which the reversal is posted. (The year and period are displayed in the field to the right.)
If you are reversing a paycheck generated in Canadian Payroll or US Payroll:
- The Reversal date may be used to reverse the paycheck and update the associated employee record in Payroll, depending on certain options set in that program.
-
There can be significant tax consequences associated with the reversal date. Before accepting or changing the reversal date, consider the following points carefully:
- If Payroll is not configured to use original dates when reversing checks, the journal entries for the reversed check and the employee's payroll data will use the reversal date you enter.
For a Canadian Payroll check, we recommend that you enter the original check's Pay Period End Date as the reversal date.
- If Payroll is configured to use original dates when reversing checks, the journal entries for the reversed check and the employee's payroll data will use the original check dates, regardless of the date you enter in this field.
- If Payroll is not configured to use original dates when reversing checks, the journal entries for the reversed check and the employee's payroll data will use the reversal date you enter.
For transactions you want to reverse, enter Yes by double-clicking the field. When you post the reversal, the bank is updated and the reversal information is sent to the subledger where the transaction originated.
If you are reversing a miscellaneous receipt for an Accounts Receivable customer or a miscellaneous payment for an Accounts Payable vendor, you can select this option to reverse the associated invoice automatically when you post the reversal.
Note: If the miscellaneous receipt or payment was for a customer or vendor with no record in Sage 300, Bank Services automatically reverses the invoice when you post the reversal. (You cannot choose whether to reverse the invoice.)
Overview
Note: Depending on how your system is set up, this desktop screen may also be available as a web screen. For more information, see the Web Screens Getting Started Guide or the help for Sage 300 web screens.
Use the Bank Reverse Transactions screen to:
- Reverse a posted payment and the original transaction associated with the payment. (You can also reverse payments using the Reconcile Statements screen.)
- Process returned customer checks and credit card payments, and update Accounts Receivable. (You can return both outstanding and cleared customer payments that originate in Accounts Receivable.)
- Reverse Bank Services-entered transactions.
These are entries that Bank Services creates (for example, to record the difference when you clear a transaction with an error or exchange difference).
- Reverse a single transaction or a range of transactions.
Note: You can reverse a transaction at any time, even during bank reconciliation.
Reversing Receipts and Deposits
When you reverse a receipt, Bank Services creates a withdrawal entry on the Reconciliation tab.
If you reverse a Bank Services-entered deposit, the entire deposit is removed from the tab, unless the deposit was created using a version of Bank Services earlier than version 5.6. (For deposits created in Bank Services 5.5, or earlier, the program creates an entry with Outstanding status for the particular reversed receipt, and displays it on the Reconciliation tab.)
Note: You cannot reverse a Bank Services-entered deposit that has been cleared. To correct the bank balance, process a withdrawal for the same amount as the cleared deposit.
Reversing Payments
When you reverse a payment that was entered in Accounts Receivable or Accounts Payable, Bank Services automatically updates the customer account in Accounts Receivable or the vendor account in Accounts Payable, releasing any paid invoices and changing the status of the payment to Reversed or Returned.
When you reverse a payment that was entered in Payroll, Bank Services updates the employee record in Payroll.