Collect! Credit and Collection Software™

  Page Table of Contents Related 'How To' Tutorials

How To Generate And Print Invoices And Statements

This document describes the process of generating and printing Client Remittance Statements/Invoices and checks. To generate a Client Remittance, you must enter the Month End menu, which is accessed by clicking the button called "Month End" on the left-hand side of your Main Menu screen. An alternate menu path is "Print\ Monthly Reports\Generate Statements".

All remittances, meaning Clients with a remittance schedule of Monthly or Clients with multiple statement cycles per month are all generated in the same menu option: Generate Statements. After you have cut off posting for the current collection period, enter the Generate Statements menu option by one of the above-noted navigational paths and follow these steps:

  1. Generate Statements
  2. Preview Statements
  3. Print Checks or Export ACH Upload
  4. Print Statements
  5. Print Reports

Month End Form

Click Here to View this Form.

Top of page.

Statement Dates

When generating statements, you will be asked to enter the date range for the period that that statements are for. Typically, this would be the first of the month to the end of the month. Collect! has built-in statement types for Weekly, Biweekly, and Daily.

Warning Note WARNING: If you are using a period other than Monthly, ensure that you have set your Client up properly under the Client Settings.

For other date ranges, like 1st to 15th and 16th to end of month, you will have to enter the dates manually.

Useful Note Statement dates should never overlap. By default, Collect! will prevent transactions from appearing on multiple statements, but the beginning date will affect Collect!'s ability to look up the prior statement for the Accounts Receivable balances.

After the Statements are generated, Collect! will put the day after the last day of the date range you used. For example, if you ran statements for a month, then it would put the 1st of the following month in the Statement Date field.

Warning Note WARNING: This is important as Printing Statements and Checks will use this date.

Top of page.

Generate Statements

Click the Month End button on your Main Menu and then click Generate Statements.


Month End form

Clients With Billing Period

Select the drop-down pick list and choose the period that you want to generate for.

Warning Note WARNING: Selecting all will include all clients for the period that you select. For example, if you select All, set the date range for last month, and you have a client that is setup for Weekly, that client will get a statement for a month, instead of a week. Do NOT select All if you have multiple billing periods.

Date Range

When you select the Billing Period, the dates will auto-fill. You can override them, if you wish.

Client #

If you want to include all Clients, leave both the From and To Fields blank. If you want to run a single statement by itself, then you may enter one client number in both the From and To fields. You can also elect to run a sub-section of Clients by selecting a client number range of consecutive numbers, i.e. From 100 To 155, would only run remittances for Client #s 100 through 155 inclusive.

Click OK in the lower right corner to initiate the generation of your Statement/Invoices. If any Statements already exist for any Client in the current billing period, you will be asked if you want to delete them. It is not advisable to retain multiple copies of Statements run on the same billing period because it becomes confusing which one was test and which one you sent out to your Client. If there is no reason for there to be a multiple, then accept the default Yes to delete any duplicates encountered.


Generate Statement/Invoice form

Top of page.

Previewing Statements

After the Statements are generated, Collect! will create Invoice records that look like the below.

The transactions are loaded as Invoice Lines. The invoice is a summary of the invoice lines.


Statement/Invoice form

Due to the complexity of the Invoice record and the different remittance types, we recommend previewing statements in report form.

On the Month End screen, click the Print Statements button.

Fill in the the parameters of the statements you generated. Reminder, the date range is the last date of the range you entered, plus 1. For example, statements generated for January 1 to January 31 would have a statement date of February 1.

Click OK, and select Letters.

On the Statements screen, select Preview, then click the Print button.

Review the statements for accuracy.

Top of page.

Printing Checks

This is an optional step. You can use Collect! to print your checks to save time for your accounting department. If you do not use this feature, you can remove the reference to check number from your statement reports.

If this is your first time printing checks, you will need to set up your banking information first.

  1. Click the menu drop-down "Print\ Customize Printing\Edit Report Template".
  2. Select the applicable check report. There are 3: Check, Gcheck, Ccheck
  3. Click anywhere in the Report Body to enter this area in Edit mode.
  4. The following are the spots in the upper portion of the report where the variables are being declared and defined:

@tvarRoutingNum = "123456789" @tvarAccount = "123456789258" @tvarBank = "Your Banks Name" @tvarBankAddr = "Bank Address Line 1" @tvarBankAddr2 = "Bank Address Line 2"

Useful Note Do NOT remove the quotes around the variable's data.

On the Month End screen, click the Print Checks button.

Fill in the the parameters of the statements you generated. Reminder, the date range is the last date of the range you entered, plus 1. For example, statements generated for January 1 to January 31 would have a statement date of February 1.

Click OK, and select Letters.

Click the Print button.

Useful Note You can select Preview if you are running a test.

Enter the first check number to use and click OK.

Useful Note Unless you have modified the default reports, you must use Check Form #1000 check paper.

Once the checks have printed, you can give them to your accountant to enter in to your accounting software.

Useful Note You can use one of the accounting software integrations that we offer in order to automatically send your receivables and payables data to your accounting software. Alternatively, you can create a custom export report to export the data to a text file to be imported in to your accounting software.

Useful Note If you use your own custom checks that are pre-printed forms which you purchase, contact us in Technical Services to discuss how we can customize your checks to print out on your preferred forms.

Top of page.

Export ACH Upload File

If you do not run checks, you can build a custom export report that exports your payables data in the format defined by your bank your ACH processor.

Simply run the report and upload it to your processor.

Top of page.

Printing Statements

On the Month End screen, click the Print Statements button.

Fill in the the parameters of the statements you generated. Reminder, the date range is the last date of the range you entered, plus 1. For example, statements generated for January 1 to January 31 would have a statement date of February 1.

Click OK, and select Letters.

On the Statements screen, click the Print button.

Top of page.

Reprint An Individual Statement From The Client Invoice Tab

Navigate to a Client.

Click on the Invoices tab and open the applicable Invoice/Statement.

Navigate to the "Print\Reports and Letters" menu.

Select the applicable Statement report:

  • Statement for Net Invoices
  • GStatement for Gross Invoices
  • CStatement for Combined Invoices

Top of page.

Printing Reports

This is optional, but recommended to give you a high level overview of your Receivables and Payables.

Useful Note You can run your Receivables and Payables reports before printing your checks to get another view on whether there are errors.

On the Month End screen, click the Receivables Report button.

Fill in the the parameters of the statements you generated. Reminder, the date range is the last date of the range you entered, plus 1. For example, statements generated for January 1 to January 31 would have a statement date of February 1.

Click OK.

On the Accounts Receivable Report screen, click the Print button.

Repeat for the Accounts Payable Report.

Useful Note Select Preview, if you don't want to print the report to paper.

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org