Summary

The Computer Checks process is used to generate checks from Accounts Payable module invoice line items. Only invoice line items that have been committed in an AP Invoices batch can be paid using the Computer Checks process (you cannot add invoices that are in an open AP Invoices batch to a Computer Checks batch). If the vendor attached to the invoice line item is set up to use Electronic AP, a check will not be generated by the Computer Checks process, but a transaction will be created in a batch in the Clearing House module Electronic AP process to create the ACH transaction to pay the vendor.

If you have generated a check outside of the application (for example, you have physically written a check to a vendor and have not recorded the payable, expense or payment of that invoice in the application), use the Manual Checks process (AP> Manual Checks) to enter the manual check. The Manual Checks process will record the payment and the expense, but it will not generate a check. 

If the Accounts Payable module is set up to create a positive pay file, the Export step on the Computer Checks process will be a required step. A positive pay file is a file that contains the checks that have been generated in the Computer Checks batch. This file is sent to your bank so that they can verify the checks for accuracy as the checks are cleared. The format of the positive pay file will vary depending on the bank they are being sent to, so the Export window is often a customized window. The AP module is set up to use positive pay on the Setup window (AP> Utilities> Setup> Checks tab> Export Positive Pay File toggle).

Once a Computer Checks batch that contains physical checks is committed, un-cleared checks will be created in the Bank Reconciliation module (BR> Clear Transactions). When you get your bank statement, you can clear the checks in the Bank Reconciliation module to update the balance of the bank account the checks were drawn on.

Step by Step

1     Open or create a new computer checks batch.

• Open the Computer Checks Batches window (AP> Computer Checks). The Batches window will display all the open Computer Checks batches.
• Select a batch and click DETAILS to open the selected batch.
• Select a batch and click the Delete button to delete the selected batch. Any uncommitted computer checks in the batch will be deleted.
• Click the Create New Batch button to create a new batch. This will open the Create Batch window.
  • If there are open batches in the Computer Checks process, you can create a new batch without affecting the open batches.
• The Batch Month and Batch Year fields default to the current date and are used for reference only and are not necessarily the fiscal month and year the transactions in the batch will be posted to. The fiscal period the transactions are posted to is determined by the journal Entry date entered when creating the GL Distribution report.
  • The batch month and batch year can be used in reporting. The checks that display in the Checks by Date Report (AP> Reports> Checks by Date) can be filtered by batch month and batch year entered in these fields.
• Click the Create New Batch button to create the new Computer Checks batch.

2     Open the Batch Overview page. 

• The Batch Overview page provides a general overview of the selected batch.
• The left navigation menu displays all the steps in the Computer Checks process.
• In the main section you'll see information about batch steps that are currently processing, next available batch steps, and the last completed batch step.
  • Batch steps that are currently processing will display a blue indicator bar to alert you that the step has not yet completed.
  • Once the preceding batch step is complete, the next available batch steps will be enabled and you can select the next step you would like to run.
    • While some batch steps are optional, any batch step that includes the Required tag   must be completed before the batch is allowed to proceed through to the Commit step.
• The Batch Outputs section on the right will display any reports or exports that have already been generated in the Computer Checks process.

3     Complete the Settings step.

• The Settings step is used to select the bank account the checks generated in the batch will be drawn from.
• Open the Settings window (AP> Computer Checks> Settings).
• The Pay From field is used to select the bank account the checks will be paid from. Click the Pay From field search button to select a bank account from a list or enter the bank account code.
  • The Pay From field will default to the default bank account selected in the AP module Setup window (AP> Utilities> Setup> General tab> Bank Account field).
  • The Pay From field will not be enabled if you are using the multi-bank checking feature. The bank account used to pay each invoice line item will be selected based on the GL account attached to the invoice line items and the bank accounts attached to those GL accounts.
  • If you are using blank check stock (AP> Utilities> Setup> Checks> Use blank check stock toggle), the name of the bank associated with the bank account will display at the top of the checks generated on the Checks step (AP> Computer Checks> Checks).
    • A bank name is entered on a bank using the Bank Maintenance window (SS> Maintenance> Bank> Bank Name field).
  • Bank accounts are created and maintained using the Bank Account Maintenance window (SS> Maintenance> Bank Account).
• The Invoices From field is used to select which database the Computer Checks batch will be generated for. This field is only visible and enabled for organizations set up to use Multi-Muni relational databases.
• Click the Save button when complete.

4     Select the invoice line items you would like to pay in the batch.

• Open the Select Invoices window (AP> Computer Checks> Select Invoices).
• The Select Invoices window is used to select the invoice line items that should be paid in the batch, and how the checks will be generated. Invoice line items in an open AP Invoice batch, selected for payment in another Computer Checks batch, or voided (AP> Void Invoices) will not display in the window and be available for payment.
  • If the Allow zero balance checks toggle is checked on the AP module Setup window (AP> Utilities> Setup> Checks tab), you can select invoices for the same vendor that create a zero dollar check. This allows you to select offsetting invoices that create a zero dollar check. If the Allow zero balance checks toggle is not checked, you will get a validation error when you try to create a zero dollar check for a vendor.
• Click Excel Export in the Ellipsis drop-down to export the grid contents to Excel if you would like to create an MS Excel spreadsheet of all the invoice line items in the window.
• The search criteria section is used to select the invoices that will be paid. Enter information in any of the fields and click the toggle to select the invoices line items that are going to be paid in the batch. For example, enter an AP Invoice batch number in the Batch Number field and click the Select button  . All of the invoice line items in the AP Invoices batch will be selected. Invoice line items that are selected for payment will have a check in the Selected column on the left. You can also manually check the toggle of each invoice line item you would like to pay. Change the sort order of the invoice line items in the window by clicking on the column headings to locate specific invoice line items.
  • The Date From and Date To fields are used to select invoice line items by the payment date on the invoice. The payment date of an invoice is set during the Settings step (AP> Invoices> Settings> Payment Date field).
  • The Fund Number field is used to select invoices by the fund number of the GL account attached to the invoice line item.
  • The Batch Number field is used to select invoice line items by the AP Invoices batch used to create the invoice. Click the Batch Number field label to select a batch number from a list. Only committed AP Invoice batches can be used to select the invoice line items.
  • The Bank Account field is used to filter the invoice line items by the bank account attached to the GL account on the invoice line item. If you do not have GL account associated with bank accounts, the filter will not affect the invoice line items in the window.
• Click the Submit button when complete.

5     Select how the checks will be generated.

• After the toggle is checked on each invoice line item you would like to pay in the batch, use the Order column to set how the checks will be generated.
  • If there are ACH transactions in the Computer Checks batch, the ACH transactions in the batch will also be affected by the grouping. For example, if the invoice line items of a vendor are grouped onto two separate checks, two separate ACH transactions are created.
• By default, all invoice line items attached to the same vendor will be grouped onto the same check. If you would like invoice line items to display on separate checks, group the checks for the vendor using the Order column.
• Invoice line items with the same vendor and Order value will display on the same check. Change the value in the Order column to group invoice line items onto separate checks. For example, if you are paying three invoice line items of the same vendor and would like two of them grouped onto a single check, set the Order value of one of the invoice line items to 1, and set the remaining two line items to 2.
  • The value in the Order column is modified by double-clicking the Order number and entering a new Order number or using the Increase and Decrease icons.
  • When an Order value has been changed, the Order column for the edited row will display in green.
  • Click UPDATE save the changes to the Order column.
• Click the Submit button when complete to save the selected invoices.
  • If you are using multi-bank checking and the general ledger account attached to the selected AP invoice is not assigned to a bank account in the correct fiscal year, you will receive an error. You can attach bank accounts to general ledger accounts (AP> Utilities> Associate Banks).

6     Print a proof list.

• The Proof List displays the invoices that are selected for payment in the Computer Checks palette, how those invoice line items are grouped onto checks, and the total number and amount of checks that will be created. The report will also display if the invoice will be paid using an ACH instead of a physical check.
• Open the Proof List window (AP> Computer Checks> Proof List).
• The Sort By drop-down menu is used to select how information will display on the report.
  • Select Vendor Name if you would like the invoices to display in alphabetical order based on the vendor name. The vendor name is the Last Name field on the vendor record (AP> Maintenance> Vendor> General tab> Last Name field).
  • Select Vendor Number if you would like the invoices to display in alphabetical order based on the vendor number.
• Check the Show vendor address toggle to include the vendor address on the proof list.
• Check the Print WO Details toggle include the Quantity, Reference Number, and WO Description for work orders included in the report.
  • This toggle will only be enabled for Wisconsin agencies using Wisconsin Highway Reporting functionality.
• Once the required report settings have been specified, click the Print button   to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.
• All of the invoice line items that were grouped onto the same checks will be totaled together, and the report will display the total of each check. If the grouping is incorrect and invoice line items should be grouped onto other checks, return to the Select Invoices step (AP> Computer Checks> Select Invoices) and use the Order column to change the grouping of the invoice line items.
• The general ledger account number on the Proof List Report is the GL account attached to the invoice.
• If the invoice line item will be paid using an ACH transaction instead of a physical check, ACH Enabled: True will display on the report. Invoice line items that are paid using an ACH transaction will not generate a physical check (AP> Computer Checks> Checks) or a journal entry line item in the batch (AP> Computer Checks> GL Distribution). When the Computer Checks batch is committed, a transaction will be created in the CH module Electronic AP process to create the ACH check. The journal entry will be created when the Electronic AP transaction is processed (CH> Electronic AP> GL Distribution).
  • If you would like to generate a physical check rather than an ACH, disable the ACH feature on the vendor record attached to the invoice (AP> Maintenance> Vendor> Details tab> ACH Status drop-down menu), and then return to the Select Invoices step on the Computer Checks batch (AP> Computer Checks> Select Invoices). When an invoice is added to the batch on the Select Invoices step, the system checks whether the vendor on the invoice is set up to use electronic AP and then sets that value. That is why you have to return to the Select Invoices step if you disable ACH transactions on the AP vendor.
• ACH checks are included in the Total Number of Checks and Total for Check Run amounts.

7     Number the checks in the Computer Checks batch.

• Select Number Checks from the Computer Checks menu. This will open the Number Checks window.
• The Beginning Check Number column is used to enter the first check number for the account line item.
• Click the Submit button to save the updated beginning check number.

8     Print the checks.

• Open the Checks window (AP> Computer Checks> Checks).
• The format of the checks that are generated depends on how the Accounts Payable module is set up (AP> Utilities> Setup> Checks tab).
• The Checks window is used to select the information that will display on the checks generated in the batch.
• The Check Date field is used to enter the check date of the checks generated in the batch.
  • The Check Date will also be applied to ACH checks that are processed in this batch.
  • The check date does not determine the fiscal period/year or journal entry date of the checks processed in the batch. The journal entry date is set when the GL Distribution Report is generated (AP> Computer Checks> GL Distribution).
  • The Check Date field is a filter option on most Accounts Payable module reports.
• The Check Title 1 and Check Title 2 fields are used to enter titles on the check. These fields will only display on the checks if the Accounts Payable module is set up to display them on the checks. If you have a custom check, these fields may not display.
  • Check titles will only be displayed on standard check stubs. When printing long check stubs, check titles will not be displayed.
• The Stub Message will display at the top of the stub above the detail line items on long check stub formatted checks. The stub message will not display on standard checks.
• The Layout field is used to select which configurable check will be used for the batch.
  • This field will only be enabled if the AP module is set up to use configurable checks (AP> Utilities> Setup> Checks tab> Check Type field).
  • Configurable checks are created and maintained on the Report Layout Maintenance window (SS> Maintenance> Report Layout).
• Once the required report settings have been specified, click the Print button   to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon   next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.
• ACH checks will not display on the report. If you are missing a check in the batch, the vendor attached to the check may be set up to use electronic AP (AP> Maintenance> Vendor> Detail tab> ACH Status drop-down menu). If you change the ACH status of an AP vendor, you will have to return to the Select Invoices step and resave the invoices in the batch in order for the new selection to take effect.

9     Print the Check Register Report.

• The Check Register Report will display the list of checks that were generated in the Computer Checks batch. The report will display the check numbers, vendor name and check amount. If you generate the report in Detail format, the report will also display all of the invoice line items that each check is paying.
• Open the Register window (AP> Computer Checks> Register).
• The Report Type drop-down menu is used to select the information that will display on the report.
  • The Summary version of the report displays the check number, vendor number, vendor name, check date and the amount paid on each check.
  • The Detail version of the report displays all of the information that is on the summary report, but it also includes the invoice line items that are paid on each check.
• Enter the first Check Number. The check numbers will increment to the end of the list.
• Once the required report settings have been specified, click the Print button   to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.

10     Generate a Positive Pay file.

• The Export step on the Computer Checks process is used to generate a positive pay file. A positive pay file is an export file that contains all of the checks that were generated in the batch. This file is sent to your bank so that the bank can verify the checks as they are cleared. The format of the positive pay file will vary depending on the format requested by your bank, so this is often a customized window.
• The standard positive pay file format is:

010840880220 000000001500000065980009222010020840880220 0000000001000000659800

• The Numbers on the first line correspond to:
  • 01 = indicates the beginning of the individual transaction line
  • 0840880220 = Bank Account
  • 0000000015 = Check Number
  • 000000659800 = Amount
  • 09222010 = Check Date
• The numbers on the second line correspond to:
  • 02 = indicates the beginning of the total line
  • 840880220 = Bank Account
  • 0000000001 = Total Number of Checks
  • 000000659800 = Total Amount

• If the file contains any electronic payments, the total electronic payment amount will be listed on a single line. The check number will be 0000000000 and the date will be the date the positive pay file was created. The final line of the file will include this total electronic payments amount in the total file amount.
• The Export step will only display on the Computer Checks palette if the AP module is set up to create the positive pay file (AP> Utilities> Setup> Checks tab> Export Positive Pay File toggle).
• Select Export from the Computer Checks menu. This will open the Export window.
• The Configuration field is used to specify the configuration for the export file.
  • Export file configurations are created and maintained on the Export Configuration Maintenance window (SS> Maintenance> Export Configuration).
  • Once a configuration is selected, click EXPORT SETTINGS to see how the export file will be configured.
• Click the Submit button to generate the positive pay file.
• Once the export has finished processing, the file can be accessed from the Notifications pane.

11     Print the GL Distribution Report.

• The GL Distribution Report displays the journal entry generated by the Computer Checks process.
• Select GL Distribution from the Computer Checks menu. This will open the GL Distribution window.
• Enter a Journal Entry Date. This will determine which fiscal period and fiscal year will be expensed.
  • You will receive a validation error if the journal entry date entered in this field is for a fiscal period that has been locked out using the Lockout Period feature (GL> Utilities> Lockout Periods).
• Once the required report settings have been specified, click the Print button   to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon   next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.
• The Computer Checks process will create the following journal entry:

• ACH checks that will be processed in an Electronic AP batch (CH> Electronic AP) will not create journal entry line items in the Computer Checks batch. The ACH checks will generate a journal entry when they are processed in the Electronic AP batch. If there are only ACH checks in the Computer Checks batch, no distribution will be created in the batch.

12     Commit the Computer Checks batch.

• Select Commit from the Computer Checks menu. This will open the Commit window.
• The Commit window will display the Batch, Journal Entry Date, Fiscal Period, and Fiscal Year for the Computer Checks batch.
• Click the Commit button to commit the checks.
• If any of the checks are attached to vendors that have been designated as Electronic AP vendors, the Commit step will create an Electronic AP batch in the Clearing House module that contains the electronic checks.
• The Commit step creates un-cleared Bank Reconciliation module checks. When you receive your bank statement, use the Clear Transactions process (BR> Clear Transactions) to clear the check. ACH checks that will be processed in the Electronic AP process will not be added to the Bank Reconciliation module until the transactions are processed in the Clearing House module.