Reports: Banking
Table of Contents
Checks and Deposits
Bank Register
Displays every check, withdrawal and deposit entered into the selected checking account within a period range. A running balance is provided.
Note: The report displays only transactions that were entered in windows to which your user ID allows access. Report Tip: It's always a good idea to review the money in and out of your checking accounts on a regular basis. Run this report for all your cash accounts. Enter the reporting date range in the Report Customization window. If everything checks out, keep the monthly report with your monthly financials.
Hint: If you number your cash accounts similarly with the exception of the last digit (1-1101, 1-1102, 1-1103, etc.) you can use AccountEdge's wildcard feature — enter 1-110* in the Selected field in the Report Customization window to generate this report for all cash accounts at once.
Use this report for:
- Weekly Reports
- Monthly Reports
Bank Deposit
Displays transactions deposited to selected checking accounts within a period range.
Undeposited Funds Report
Displays transactions deposited to selected checking accounts within a period range.
Electronic Payments Register
Displays every processed electronic payment for the selected checking account within a date range.
Note: If this report is printed when recording a Prepare Electronic Payments transaction, the report displays the current transaction only.
Unprocessed Electronic Payments
Displays every Spend Money, Pay Employees and Pay Bills transaction that have been recorded as Grouped with Electronic Payments, but have not been processed from the Prepare Electronic Payment window.
Reconciliation Report
Provides a reconciliation summary and a list of the uncleared checks and deposits for all, one or selected checking accounts as of a specified date. Note: This report can be used for other accounts like credit cards, expense accounts, etc. You can display and print reconciliation reports for previously recorded account reconciliations, that is, reports for accounts that were reconciled using the Reconcile Accounts window.
Note: You can print the Reconciliation Report from three locations:
- From the Index to Reports window: to select the date of a previously recorded reconciliation: Highlight the report name on the Banking tab of the Index to Reports. Click the Customize button. Select or enter an account in the Accounts field. (The list of previously recorded statement dates isn't available if All or Selected appears in the Accounts field.) From the Select by field on the Advanced Filters tab of the Report Customization window, choose the option List of Recorded Statement Dates. Then, from the Statement Date drop-down list, select the date from the list.
To enter a reconciliation date: highlight the report name on the Banking tab of the Index to Reports. Click the Customize button. Select or enter an account in the Accounts field. From the Select by field on the Advanced Filters tab of the Report Customization window, choose the option Entered Statement Date. Then, enter the date in the Statement Date field.
Only this location provides the ability to display and print previous reconciliations that were recorded using the Reconcile Accounts window.
- From the Print button on the Reconcile Accounts window: you can print a report that shows a reconciliation summary and cleared and uncleared transactions the way they are marked in the window.
- From the Print Report button: to use this location, you must first click the Reconcile button in the Reconcile Accounts window after you've successfully reconciled an account. This report shows a successfully reconciled account summary with cleared and uncleared transactions as they are marked in the window.
Note: The report displays only transactions that were entered in windows to which your user ID allows access.
Statement of Cash Flow
Provides the changes in cash and cash flow equivalents for the period.
Cash Flow Analysis Report
Forecasts cash needs for a specified linked checking account, based on information you've entered throughout AccountEdge. Information includes all recorded transactions, along with recurring transactions entered in the Banking, Payroll and Accounts command centers. Recurring transactions entered in the Sales and Purchases command centers will not appear in this report.
Unlike all other reports that you customize using the Report Customization window and display and print using the Report Display window, the Cash Flow Analysis report is viewed and printed through the Cash Flow Worksheet window. There are two filter selections in the Worksheet view of that window.
The Cash Flow Worksheet window can be found by clicking Analysis in the Banking command center.
The first window is a worksheet. Enter the number of forecast days and review the worksheet. Add, change or delete entries on the worksheet. When everything is complete click Analyze Cash Needs. To print the Cash Flow analysis report, click the Print button at the bottom of the window.
Use this report for:
- Analyzing Your Cash Flow.
Transaction Journals
Cash Disbursements Journal
Displays all transactions entered in the Spend Money, Settle Returns & Credits, Pay Employees or Pay Bills windows within a period range.
Note: The report displays only transactions that were entered in windows to which your user ID allows access.
Note: If Selected appears in the Job column, this indicates that more than one job has been assigned to a line of an employee payment.
Use this report for:
- Weekly Reports
Cash Receipts Journal
Displays all transactions entered in Receive Money, Settle Returns & Debits and Receive Payments windows. Note: The report displays only transactions that were entered in windows to which your user ID allows access. Use this report for Weekly Reports.
Recurring Transactions
Recurring Checks
Displays the names of recurring check transactions, dates last recorded, frequencies and dates next due.
Recurring Deposits
Displays the names of recurring deposit transactions, dates last recorded, frequencies and dates next due.
Recurring Transactions List
Displays the names of each recurring transaction and for each one, the type, the frequency of posting, the date last posted, the next due date for posting, the kind of alert you receive and the number of posts remaining on the schedule.
To Do List
Recurring Banking Transactions Report
Displays a list of recurring checks, deposits and General Journal entries from the To Do List window.
Report Tip: If you use the recurring transaction feature, it's good to run this report just to check that you've entered all the recurring entries for the month. Enter the month-end date as the As Of Date in the Report Customization window. When reviewing the report, look at the Last Posted Date to see if it was posted during the month.
Note: If it looks like it didn't get posted last month, check the Trial Balance report before entering it. Someone may have posted it without using the recurring transaction feature. Use this report for Monthly Reports.