Welcome to Forums Sign in | Join | Help | Forums
in Search


Forums » Internal Forums » Accounts Payable » Check Register

Check Register

Last post 10-01-2007 4:54 PM by Angie Markert. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next

  • 09-13-2007 10:52 AM

    • Angie Markert
    • Not Ranked
    • Posts 6
    • Organization: Unitarian Universalist Association of Congregations

    Check Register

    Reply Contact
    I am a financial/accounting consultant with the UUA and need assistance running a check register that actually agrees with the checks posted to the general ledger. There are so many ways and dates to use this report and I have been unable to come up with the correct combination of criteria.

  • 09-18-2007 4:24 PM In reply to

    Check Register

    Reply Contact
    Hi Do you mean you are comparing the Expense codes or Accounts Payable to the checking account ? The only way we are able to make sure the check register exactly matches GL Reports would be to keep the Invoice date the SAME as the Check date - not that the accountants like that.

  • 09-18-2007 4:28 PM In reply to

    • Ed Griffis
    • Top 500 Contributor
    • User Since: 2004
    • Posts 29
    • Organization: Boys and Girls Clubs of Lancaster
    • Products:  The Financial Edge

    Check Register

    Reply Contact
    You can dump the GL to excel and then sort by type of posting which then would enable you to itemize the checks posted. this could be matched to a dump of the check register to excel also. not hard to do for selected periods.

  • 09-18-2007 4:53 PM In reply to

    Check Register

    Reply Contact
    Angie, I would suggest running a query that includes check date and also check post date (2 different fields, should be the same date or at least the same month-but sometimes users make errors)

  • 10-01-2007 4:49 PM In reply to

    • Angie Markert
    • Not Ranked
    • Posts 6
    • Organization: Unitarian Universalist Association of Congregations

    Check Register

    Reply Contact
    Thanks, Diane. As it turns out, the report showed an incorrect total. When I exported the check register to a spreadsheet, and added a formula, the report totaled exactly the general ledger amount, and not the report amount. The UUA IT will send them a file so they can fix it.

  • 10-01-2007 4:52 PM In reply to

    • Angie Markert
    • Not Ranked
    • Posts 6
    • Organization: Unitarian Universalist Association of Congregations

    Check Register

    Reply Contact
    Thanks, Ed. When I exported the check register to Excel to facilitate the comparison, I discovered that the check register had totalled incorrectly. When I applied a formula for the total, it exactly matched the general ledger. The UUA IT will send the file to Financial Edge for correction.

  • 10-01-2007 4:54 PM In reply to

    • Angie Markert
    • Not Ranked
    • Posts 6
    • Organization: Unitarian Universalist Association of Congregations

    Check Register

    Reply Contact
    Thanks, Ina. As it turns out the check register did not have the correct total. When I exported it to Excel and applied a formula to the report, the total was not what the check register showed but the amount that was posted to the general ledger. The UUA IT department will send the file to Financial Edge so they can correct it.
Page 1 of 1 (7 items)