Cash Requirements Report - click to view report
This report provides a listing, by General Ledger Account Number, of the Accounts Payable Invoice Number, Vendor Name, Invoice Date, Invoice Amount and Discount Amount for an inputted date range. The report also sorts by General Ledger Account Segment. In this report, segments are established for Department and Location. The report could be used to compare expenses on a department by department basis between different business offices or stores. |
 |
Repetitive Invoice Listing by Division- click to view report
This report lists all repetitive A/P invoices by vendor showing the billing amount per invoice and total billed per date. The report shows billing cycle, billing start date, date of last bill and number of payments to date by division and by vendor. |
|
Vendor Listing by Last Purchase Date- click to view report
This report lists all Vendors by Vendor Number. The report includes Vendor Name, Address and Last Purchase Date. You have the ability to input a beginning date range and the report will print all Vendors with a last purchase date from the inputted date to the present. |
|
Vendor Top 20 Listing- click to view report
This report lists the top 20 A/P vendors by current year and prior year purchases. The report is sorted by highest dollar amount of current year purchases. The report also provides the dollar percentage of the total by vendor for current and prior year purchase. |
|
Accounts Payable Purchase By Location- click to view report
This report provides a listing, by General Ledger Account Number, of the Accounts Payable Invoice Number, Vendor Name, Invoice Date, Invoice Amount and Discount Amount for an inputted date range. The report also sorts by General Ledger Account Segment. In this report, segments are established for Department and Location. The report could be used to compare expenses on a department by department basis between different business offices or stores. |
|
Accounts Payable Trial Balance Report- click to view report
This report prompts for an "as of" date. It provides a more readable format that the standard Sage MAS 90 AP Trial Balance Report. This report includes all invoices and all vendors and subtotals by division. |
|
Accrual Report- click to view report
This report helps users to close out Accounts Payable on the last day of the month. All invoices vouched the following month are updated to the G/L on the date posted regardless of the invoice date. This report will pick up all invoices with an invoice date equal to or less than the month end cutoff date and a transaction date greater than the cutoff date. The month end cut off date is the input parameter. The report is a great tool to be used as a basis for reversing Journal Entries and can be run at the end of the G/L closing cycle. The report shows details and summary information by G/L Debit Account including Account #, Account Description, Transaction Date, Source Journal, Source Batch, Vendor, Invoice Date, Invoice # and Amount. |
|
Source Batch Reconciliation- click to view report
This report lists all the Invoices in the AP_12 Invoice History File by A/P Invoice Register Number To reconcile with G/L Postings. |
|
Cash Requirements 8 weeks out- click to view report
For this report, the user inputs a date and report displaying cash requirements 8 weeks into the future, instead of the 4 weeks the standard Sage MAS 90, 200 Cash Requirements report. |
|
Check Verification for WellsFargo (other banks available)- click to view report
This report is used to prevent check fraud by sending check information to the bank and utilizing the bank's recent service offerings. It provides a method where a client can email check data to their bank where it is used to match against checks being cleared by the bank. Click above for an example of the documentation available for the report. |
|
Purchase Orders by General Ledger number- click to view report
The POs by GL Number Report groups purchase orders by General Ledger expense account numbers from the lines of the purchase order. |
|
Reversed and Voided Check Report- click to view report
This report lists reversed and voided checks by bank code. |
|
| |
| |
