Government Transaction Reconciliation Report

This report displays all government payables reconciled on a single Government Payable statement or on a range of statements.

You can select different report versions, including the default Transaction Reconciliation – Government Payables report and any reports that are created based on that report in the Reports/Marketing area. Any custom reports must be saved to the main Transaction report group to be available for selection. Available options do not include My Reports or Report Quick View reports.

The layouts set to print in the Reports/Marketing area for the selected report will be used. If multiple layouts are set to print for the selected report, all layouts will be generated.

There are two ways to go about creating the report:

• Locate a specific reconciliation for which to run the report.
  1. Access the Reconciliations area.
     1. To access the General Ledger from the Home screen, do one of the following:

     1. • Click General Ledger on the navigation panel.
        • Click Areas > General Ledger on the menubar.
        • Click the down arrow next to Home on the options bar and select General Ledger.

     To access the General Ledger from another area of the program, do one of the following:

     • Click Home > General Ledger on the menubar.
     • Click the down arrow next to Home on the options bar and select General Ledger.

     2. Click Reconciliations on the navigation panel, or click Areas > Reconciliations on the menubar.
  2. Click Government Payables under Reconciliations on the navigation panel.
  3. The Government Payable Reconciliations screen displays. Enter your desired search criteria to populate the list.

     To locate reconciliations that match specific criteria, use the search bar. Make a selection in each dropdown menu to locate the desired reconciliation. The fields vary, depending on the menu options you choose.

     

     These are the choices in the first dropdown menu:

     • Agency
     • Date Entered
     • Entered By
     • Government Entity Code
     • Government Entity Name
     • Master Statement #
     • Paid Status
     • Payment Address
     • Payment Contact
     • Recreated
     • Refer #
     • Reopened
     • Reversed
     • Rework
     • State/Province Code
     • State/Province Name
     • Statement #
     • Statement Status

     The choices available in the second dropdown menu vary, depending on the selection you made in the first dropdown.

     • Equals: Enter the search criterion (e.g., the exact government entity code or user ID) in the field to the right, or select the correct date from the dropdown calendar (if applicable). Click Find.
     • Contains: Enter at least one character of the criterion.
     • Within Range: Search between two different calendar dates of your choice. Click the down arrow to the right of each field to choose dates from the dropdown calendars. Click Find.

     Notes:

     • If you selected Paid Status, select Unpaid, Paid, or Closed from the second dropdown. Click Find.
     • If you selected Recreated, Reopened, or Reversed, select Include or Exclude from the second dropdown. Click Find.
     • If you selected Rework, select Include, Exclude, or Only from the second dropdown. Click Find.
     • If you selected Statement Status, select Approved, Finalized, or Suspended from the second dropdown. Click Find.
     • If you selected Refer #, select Disbursement, Journal Entry, Receipt, or Voucher from the third dropdown. Click Find.

     To see the filter that is currently applied to the list, hover over the Search where text.

     You can apply multiple filters if necessary.

     1. To apply multiple filters to the list, do one of the following:
     • Click the Edit Filter button . 
     • Press Ctrl + E
     2. The Edit Filter pop-up window displays. 
        
        Note: You can also use the Edit Filter button, rather than the search bar, to apply a single filter to the list if you prefer.

     

     3. Select and/or enter your desired search criteria using the dropdown menus and fields, and then click the Add button. The Name, Compare Type, and Criteria for your filter display in the list. Click one of these column headings to sort the list by that column. To reverse the sort order, click the column heading again.
     4. To apply additional filters, enter additional search criteria and continue clicking Add. To remove a filter from the list, select it and click the Delete button.
     5. Click Finish when you have applied all of your desired filters.
        
        To exit the dialog without applying any filters, click Cancel.

     Reconciliations matching the criteria selected in the filter display in the list. To sort by a different column, click the column heading by which you wish to sort. Click one more time to change the sort order (from ascending to descending, or vice versa).

     Click the Select Columns link label to change the columns that display in the list or the order in which they display.

     Detail for the highlighted reconciliation displays below the list.

  4. Select the appropriate reconciliation.
  5. On the menubar or options bar, click On Demand > Government Transaction Reconciliation Report. The Government Transaction Reconciliation window displays.
  6. Select the desired version of the report from the Report dropdown menu.
  7. Leave the default of Selected item checked to report only on transactions on the statement you selected.
  8. Click Preview. The Print Preview screen displays.
     
     Click Page Setup to specify the print parameters or to change the printer to which the document should be sent. Fill this window in as you would for any other document.
     
     Change the Zoom percentage to change the size of the document on the screen for easier viewing.
     
     Click the Single Page View , Double Page View , and Multiple Page View buttons to specify the number of pages that should display on the screen.
     
     Use the First Page, Next Page, Previous Page, and Last Page buttons to scroll through the pages on the screen, or enter the desired page number in the field provided and press [Enter].
     
     Click the Print button to print the document. Your Print window displays. Print this as you would any other document.
     
     Click Close to exit the screen without printing the document.
• Search for a statement or a range of statements for which to run the report.
  1. Access the Reconciliations area.
     1. To access the General Ledger area from the Home screen, do one of the following:
        • Click General Ledger on the navigation panel.
        • Click Areas > General Ledger on the menubar.
        • Click the down arrow next to Home on the options bar and select General Ledger.

        To access the General Ledger from another area of the program, do one of the following:

        • Click Home > General Ledger on the menubar.
        • Click the down arrow next to Home on the options bar and select General Ledger.
     2. Click Reconciliations on the navigation panel, or click Areas > Reconciliations on the menubar.
  2. Click Government Payables under Reconciliations on the navigation panel.
  3. On the menubar or options bar, click On Demand > Government Transaction Reconciliation Report. The Government Transaction Reconciliation window displays.
  4. Select the desired version of the report from the Report dropdown menu.
  5. Deselect the Selected item checkbox.
  6. Type the correct Date entered in the field provided, or click the down arrow to the right of the field to choose a date from the dropdown calendar. Blank out the data to report on all dates.
  7. Change the Accounting month if applicable. Blank out the data to report on all accounting months.
  8. Optionally select an Entered by employee. You can also select All Active Employees.
  9. To report only on statements payable to a specific entity, select the appropriate vendor code from the Government payable dropdown menu. You can also select All.
  10. Select a specific State/Province, or leave the default of All.
  11. Enter the Statement # you are seeking, if known. You may also enter a range of statement numbers, or blank out the data to report on all statement numbers.
  12. Enter the Master statement # you are seeking, if known. You may also enter a range of master statement numbers, or blank out the data to report on all master statement numbers.
  13. Click Preview. The Print Preview screen displays.
      
      Click Page Setup to specify the print parameters or to change the printer to which the document should be sent. Fill this window in as you would for any other document.
      
      Change the Zoom percentage to change the size of the document on the screen for easier viewing.
      
      Click the Single Page View , Double Page View , and Multiple Page View buttons to specify the number of pages that should display on the screen.
      
      Use the First Page, Next Page, Previous Page, and Last Page buttons to scroll through the pages on the screen, or enter the desired page number in the field provided and press [Enter].
      
      Click the Print button to print the document. Your Print window displays. Print this as you would any other document.
      
      Click Close to exit the screen without printing the document.