Use Quick Entry and Reconciliation
- You must have your statement from the bank for the account you want to reconcile, so you can compare lines for reconciliation.
- Configure theBank Statement Eventbusiness process and security policy in the Banking and Settlement functional area.
- Security: These domains in the Banking and Settlement functional area:
- Process: Bank Reconciliation
- Process: Bank Statement - Edit
- Process: Bank Statement - Reporting
- Security:Reports: Cash Forecast Reportingdomain in the Cash Management functional area.
With quick entry and reconciliation, you generate bank statement lines and reconcile them with your account transactions as part of a single task. You retrieve a list of all your account transactions that fall within the bank statement dates, and then select the matching transactions in your bank statement. Workday immediately reconciles the lines that you select, and you don't need to enter bank details manually.
If you can't find a matching account transaction for a bank statement line, create an ad hoc transaction and then reconcile the bank statement line with this new transaction.
- Navigate to theRecord Bank Statementtask. SelectQuick Entry Bank Statement,and enter the bank statement dates. Workday automatically builds a bank statement by retrieving all account transactions that fall within these dates for the company and bank account that you specify.
- Specify the bank account to reconcile. You can select an account by bank, by company, or by company hierarchy.
- TheCurrencysets to the bank account currency.
- SelectQuick Entry Bank Statement.
- Specify theStatement Beginning Date, and theStatement Datefrom the bank statement. Workday selects lines from your account that fall within these dates.
- Specify theBeginning BalanceandEnding Balancefrom the bank statement.
- On theCleared Activitytab, check transactions that have matching detail lines in your bank statement.Workday automatically reconciles the transactions that you select.
- For bank statement lines without corresponding account transactions, such as bank fees, interest payments, or discounts, you must create an ad hoc transaction to add that line to your account. SelectSave as Draftand close this statement entry.
- To return to a quick entry bank statement, access theFind Bank Statementsreport. Select the organization and optional search criteria to help you find this unreconciled statement. If you have more than one unreconciled bank statement, make sure to select the one for the correct bank account and statement period.
- Select from the related action menu to the left of the bank statement.
- On theEdit Bank Statementpage, the ad hoc transaction now displays. Check the box to select this line for reconciliation. If necessary, continue adding ad hoc transactions until theDifferencefield is zero.
- When you've reconciled all lines in the quick entry bank statement, submit it for approval and complete the reconciliation process.If you selectSave for later, the statement remains inDraftstatus even if all of the transaction lines are reconciled.
To make changes after reconciling and approving a bank statement, select
Bank Statement > Change
from its related action menu. You might want to:
- Clear the check boxes to unreconcile and remove account transactions from the bank statement.
- Remap bank statement lines to account transactions.
The cancel, change, and reconcile tasks are available as related actions on
Approved
bank statements.