More information

Check/Voucher Register

Access this report using Reports>Check/Voucher Register.

Use this report to print a list of posted checks and/or vouchers. This report:

Assists in reconciling your bank accounts and may be required at year-end by auditors.
Contains the Chart Settings feature, which allows you to generate custom line, bar, column, or pie charts from reports. For more information, see Chart Settings - Setup Tab.
Contains additional items, columns, and filters if any user defined fields were created by the Administrator using Organization>Set Up User Defined Fields Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No are available in the Items by Page group box on the Content tab. User defined fields with a field type of Currency follow the formatting of the organization's functional currency.

The data that appears on this report was set up using:

Activities>Check Writing>Write Checks
Maintain>Accounts Payable>Vendors
Transactions>Accounts Payable>Enter Manual A/P Checks
Activities>Payroll>Transfer to Accounting

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Current Transaction Dates are also required to specify the date range for the data included in the report.

Use this tab to determine what data to include in the report and to define the report layout.

By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
Document Number	The number associated with the document.
Document Date	The date of the document.
ID	The Vendor ID or Employee ID assigned.
Class	The vendor or employee class (Maintain>Accounts Payable>Vendors or Maintain>Payroll>Employee Information).
Type	The vendor or employee type (Maintain>Accounts Payable>Vendors or Maintain>Payroll>Employee Information).
Source	A source of Vendor, Employee, or Payroll Processing Group. The report shows V, E, or P.
Name	The name printed on the checks or vouchers.
Payee	The payee information that was entered on the Write Checks form.
Payee Address	The address of the payee.
Vendor Tax ID Number	The Tax ID for the vendor associated with this document. Note that if Vendor Tax ID Type Social Security Number (S) was selected, only the last four digits of the number display. To view the entire social security number, you must have been granted Display Sensitive Data rights for Maintain>Accounts Payable>Vendors. These rights are granted by the Administrator using Security>Set Up Organization Menus form.
Issue 1099	A designation of Yes or No. Yes indicates this vendor receives a 1099 form, and No indicates the vendor does not receive one.
Document Description	The description entered for the designated document.
Document Amount	For functional currency, the document amount entered during transaction entry. For non-functional currency, the Source Document Amount times the Exchange Rate.
Source Document Amount	For non-functional currency, the document amount entered during transaction entry.
Matching Document Number	The number assigned to the related document.
Matching Document Date	The date assigned to the related document.
Session ID	The session ID assigned to this batch of documents.
Transaction Source	The document's transaction type, such as APC, APS, APV, BD, CD, CDS, CL, ENC, ENL, PRC, PRS, PRV, or VCK. The report prints the transaction type in the heading of the report.
Payment Type	The payment type associated with the document—either Check or Voucher.
EFT Status	The status of the electronic funds transfer. The system displays "Sent" if the file has been created and sent. The system displays "Created" if the file has been created but not sent. Or, this column is blank if there is no electronic funds transfer for this document.
Cleared Status	The status of the document—Outstanding, Cleared, or Voided. The report prints OS, CL, or V.
{Segment Name} Code	The code assigned to the segment. The report shows a segment code—01, 201, 11001, for example. The report prints one column for each segment, such as Fund Code or GL Code.
{Segment Name} Title	The actual title assigned to the segment. The report prints the title, such as Operating Fund, Housing, or Cash in Checking.
{Segment Name} Short Title	Usually the first 15 characters of the Account Title. The report prints an abbreviated title, such as Oper Fund, Housing, or Cash.
Effective Date	The document's effective date.
Entry Type	The entry type chosen during transaction entry—Normal, End of Year Adjustment, Adjust Opening Balance, or Beginning Balance. The system prints an N, A, AO, or UO. In order to include transactions for End of Year Adjustment and Beginning Balance, these options must be selected using the Options tab.
Transaction Description	The transaction description of the document.
Source Currency	The currency type assigned to the session, such as USD, CAD, EUR, GBP, or MXN. Currencies were created and activated by the Administrator using the Organization>Currency Setup form.
Source Currency Description	The description associated with the currency, such as US Dollar, Canadian Dollar, or Euro.
Transaction Amount	The amount entered for the transaction document.
Source Transaction Amount	For non-functional currency, the amount entered for the transaction document.
Spoiled	A designation of Yes or No depending on if the check was recorded as spoiled (Activities>Check Writing>Check Spoilage).
Check Address Code	The vendor’s check address code, such as Main or Austin Office.
{User Defined Field} - Vendors	A vendor type user defined field and its data. There is a separate column for each field that was created by the Administrator using Organization>Set Up User Defined Fields.
{User Defined Field} - Transaction Documents	A transaction documents type user defined field and its data. There is a separate column for each field.
{User Defined Field} - {Segment Name} Code	A segment type user defined field and its data. There is a separate column for each field.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to set up any Available Options for the report.

Options	Description
Year-End Adjustments	Select this option to include year-end adjustments on the report. This entry type was designated during transaction entry.
Summarize Amounts	Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.

To print totals for each account code combination, select the Show Totals box on the Content tab.
The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).
To print spoiled checks, filter on Spoiled = Yes and select the following columns, which relate to check spoilage: Document Number, Document Date, Document Description, and {Segment Name} Code.