|
Month End Reports
We have had the question from customers as to what reports should be run at a month end. The
following is a list of recommended reports that should be run.
Of course, each company's needs will vary as to what reports are
needed. There will probably be other reports that will suit your
needs. Keep in mind that system retains all data, so that almost
any report can be run at anytime.
Our recommendation is if you don't need or look at the report at a
month end, don't waste the paper. The items below in red
are highly recommended.
Accounting
- General Journal Report
- Checks by Bank and Ledger Account
- Balance Sheet
- Income Statement
Banking
- Bank Account Transactions by Type/Date
Customer
- Collection Report (Serves as an Age Trial of customers' outstanding balances)
Sales
- Payment Detail Totals - Monthly
- Sales Tax Report by Tax Rate
- Sales Persons Commissions
- Invoice Sales Person Analysis by Month
- Invoice Customer Analysis by Month
- Invoice Manufacturer Analysis by Month
Inventory
- Stock Mgmt - Inventory Items Overdue
- Stock Mgmt - Inventory Items Low Stock
Purchases
- A/P Detail Aging by Supplier
- Payables Paid Detail Totals - Monthly
top of page
Resolution Size
In order to display correctly, the resolution must be a minimum of
800 x600 and small fonts must be used.
top of page
Import to Excel
Access provides the ability to import a report directly into an Excel spreadsheet.
For some reports, this does not
always work correctly. This is usually caused by heading
formats that causes confusion in Excel. The following provides
a tip on how to get around this problem.
- Display the report in preview mode
- Click on Tools
- Click on Office Links
- Click on Publish it with MS Word (This will open Word and display the report)
- Click on File
- Click on Save as
- Change the type of file Text Only
- Provide a file name
- Close Word
- Open Excel
- Open the saved text file (Excel will display import options)
- Select Delimited (Should be the default)
- Click on Next
- Make sure the Delimiter tab option is checked (Should be the default)
- Click on Next (Verify the columns are displayed correctly)
- Click on Finish
- Data should be imported into correct columns
top of page |
