MKMS Help

Print the Transaction Summarization Reports

This Help File Page was last Modified on 11/08/2013

Print the Transaction Summarization Reports

This Help File Page was last Modified on 11/08/2013

Previous topic Next topic  

Print the Transaction Summarization Reports

This Help File Page was last Modified on 11/08/2013

Previous topic Next topic  
These Accounts Receivable and Accounts Payable reports (as listed below) should be printed for each month that has passed since the Ending Date of the last month that was Closed within your existing (old) General Ledger system (whether manual or automated).

 

In the Accounts Receivable module, print the following reports and perform the associated tasks as outlined below:
Unallocated Receipts/Credits Report - Print this report, then use Allocate (or use the Post Pending Credits & Deposits process) to apply as many of these Deposits and Credit Memos as possible to the appropriate Sales Invoices.

HelpFilesOpenCreditsDepositsOptions

Open Credits & Deposits Report dialog

 

Unallocated Receipts/Credits Report - After you have allocated as many Receipts and Credit Memos as possible, Reprint the report, then save this copy.
If you have allocated all of the unapplied Receipts and Credit Memos, there will be no records remaining to be reported so just note that fact.

 

HelpFilesNoRecordsmatchCriteria

There are no records matching your criteria

 

Note: In the screen examples below, to get the easiest to use, and most concise report versions, pay particular attention to the Dates selected and the Options recommended!
Cash Receipts Report - Normally, you will deposit all Receipts into the same Bank account when initially starting the (new) General Ledger System.
Perhaps later, you will transfer monies from the master account to subordinate accounts like a Payroll or Savings account.
If all monies received from Subscribers are initially deposited into the same Bank account, or you deposit into multiple accounts but use the same Batch Number for any Receipt - regardless of Bank (which is not a good idea) - use the options shown in the illustration below to create the required Cash Receipts Report.
Print for Specified Dates,
By Date Paid,
Pay special attention to the Start Date and End Date fields.

HelpFilesCashReceiptsReportSpecifiedDates

  Cash Receipts Report Options for one Master Bank Account

 

If all Receipts from Subscribers are initially deposited in more than one Bank account, use the options shown in the illustration below to create the required Cash Receipts Reports.
Normally, you should use a different Batch Number for each Bank to which you are posting Receipts.
This enables you to distinguish which Deposits went to which Bank as you review the Cash Receipts Report.
This is because only one Bank should receive deposits, within one Batch Number.
So, if you use a separate Batch Number when recording the Receipts that are to be deposited into each Bank, print the Cash Receipts Report for the whole month using the options listed above.
oMake a Note of every Batch Number that was used that month.
oThen printing all of these batches separately will allow you to know which Receipts went to which Banks and When (the dates) they were deposited.
oSave this report!
Then, print the Cash Receipts Report as follows:
oPrint for One Batch Number,
oBy Date Paid,
oEnter that Batch Number,
oPay special attention to the Start Date and End Date fields, which should span the entire month (In case multiple day's Receipts were included in one deposit with one batch number spanning these days).
oRepeat this until all of the batches are printed for the month.
oSave each copy.

HelpFilesCashReceiptsReportOneBatchFullMonth

Cash Receipts Report Options for multiple Bank Accounts

 

Sales Analysis Report.
Print the Summary version for All Departments and pay special attention to the Start Date and End Date fields.

HelpFilesSalesAnalysisReportSummaryOptions

  Sales Analysis Report - Options tab

 

Sales Taxes Invoiced Report - If you reimburse the Sales Taxing Authorities on an "as Billed" basis, AND you must charge a Local and a National Sales Tax, print this Sales Taxes Invoiced Report.
If you reimburse the Sales Taxing Authorities on an "as Billed" basis and only charge a Local (State) Sales Tax, you do not need to print this report because those Sales Taxes that were Invoiced are already included in the Sales Analysis Report data (that was printed above).
If you must print this report, Print the Summary version for All Divisions and pay special attention to the From and To Date Range.

HelpFilesSalesTaxesInvoicedSummary

Sales Taxes Invoiced Report - Options

 

Sales Taxes Collected Report - If you reimburse the Sales Taxing Authorities on an "as Collected" basis, print this Sales Taxes Collected Report.
Print the Summary version for All Divisions and pay special attention to the From and To Date Range.

HelpFilesSalesTaxesCollectedSumary

Sales Taxes Collected Report - Options

 

Close the Month (except for the current month - see below).
In many cases, you will have previously printed the recommended reports outlined in the Close the Month chapter.
If you have not done so, also print those reports, but they do not need to be saved with this batch of reports that will be used later to Summarize the Startup Transactions.
Repeat this report printing process until you have completed the reports for all the months prior to the current month.

 

In the Accounts Payable module, print the following reports and perform the associated tasks as outlined below:
Unallocated Payments/Credits - No dialog is required, Print the report if any records exist.
Print this report, then Apply as many of these Unapplied Payments and Credit Memos as possible to Invoices.

 

HelpFilesPreviewOrPrintQuery

Preview this Report?

 

Unallocated Payments/Credits - After you have allocated as many of the Unapplied Payments and Credit Memos as possible, Reprint the report, then save this copy.

HelpFilesUnallocatedPaymentsPreview

Unallocated Payments - Preview tab

 

There may be no records remaining to be reported.

 

HelpFilesNoRecordsmatchCriteria

There are no records matching your criteria

 

Note: In the screen examples below, to get the easiest to use, and most concise report versions:

Please pay particular attention to the Dates selected and the Options recommended!

Print Checks - To ensure that there are no unprinted Checks remaining in the Check Printing Queue.
Print the Checks for All Bank Accounts from which you draw checks.
Print your normal Check format, Print For All Vendors.

HelpFilesPrintChecksDialog

Print Checks dialog

 

Unprinted Checks Report - There should be none, if you printed all unprinted checks.

HelpFilesUnprintedChecksReportPreview

Unprinted Checks Report - Preview tab

 

If no checks are unprinted, this will be your response.

HelpFilesThereAreNoRecordsMatchingYourCriteria

There are no records matching your criteria

 

Check Register - Print the Check Register Report following the instructions below:

 

HelpFilesCheckRegisterOptions

Check Register Report Options

 

Print for All Bank Accounts.
Print for Payments Only
Pay special attention to the Start Date and End Date

HelpFilesCheckRegisterReportPreview

Check Register Report - Preview tab

 

Purchase Analysis Report - Use the Summary version.
Print the Summary version for All Vendors, All Items, etc.
Pay special attention to the From and To Date Range.

HelpFilesPurchaseAnalysisReportSummary

Purchase Analysis Report - Options tab

 

Taxes Billed Report - Summary version should be OK.
Pay special attention to the From and To Date Range.

HelpFilesTaxesBilledSummary

  Taxes Billed Report - Options

 

Close the Month (except for the current month - see below).
In many cases, you will have previously printed the recommended reports outlined in that Close the Month chapter.
If you have not done so, also print those reports, but they do not need to be saved with this batch of reports that will be used later to Summarize the Startup Transactions.
Repeat this report printing process until you have completed the reports for all the months prior to the current month.

 

What's Next?
Summarize the Startup Transactions using these reports.
Post the Summarized Transactions.