|
PeachPro sets you free
|
| ACH Summarized Check Posting |
Make bank account reconciliation easier! If you pay more than one A/P invoice with a single check, then multiple entries are made in the G/L cash account for each invoice. If you consolidate all transactions to one posting per account number, you lose valuable data. If you feel too limited by these options, then ACH - Summarized Check Posting is just for you!
With ACH - Summarized Check Posting, you have the option to consolidate the cash entry to one posting for each check. This enhancement gives you the flexibility to transfer concise information that is easy to analyze in your General Ledger.
To use ACH - Summarized Check Posting, choose the option Create G/L Entries from the Processing menu in Accounts Payable. You will then see the following:
+------------------------------------------------------------------------+ |+======================================================================+| ||APPROC2 Create G/L Journal Entries COMPANY ID: SP || ||07/10/96 Software Professionals, Inc GENERATION #: 01|| |+======================================================================+| | +====== TRANSFER OPTIONS =======+ | | | L - List G/L Transfers | | | | | | | | C - Consolidate G/L Transfers | | | | | | | | T - Create G/L Transfers | | | +===============================+ | +------------------------------------------------------------------------+
After selecting List G/L Transfers, choose Consolidate G/L Transfers and you will then see the following prompts:
+-------------------------------------------------------------------------+ |+=======================================================================+| ||APPROC2 Create G/L Journal Entries COMPANY ID: SP || ||07/10/96 Software Professionals, Inc GENERATION #: 01|| |+=======================================================================+| | Do you want to use a cutoff date for G/L Journal Entries? (Y/N) N | | Posting Date: 07/10/96 | | | | +==== CONSOLIDATION OPTIONS =====+ | | | A - All Accounts | | | | P - A/P Accounts | | | | C - Cash Accounts | | | | G - One G/L Entry Per Check | | | +================================+ | +-------------------------------------------------------------------------+
Highlight option one; G/L Entry Per Check and press enter to select. When selecting this option, you cannot have All Accounts and Cash Accounts selected, but you can have A/P Accounts selected. After marking your selections, press F10 to consolidate.
Before using ACH - Summarized Check Posting, a portion of your List G/L Transactions report in A/P will look similar to the following:
+-------------------------------------------------------------------------+ |RUN DATE: 07/10/96 Software Professionals, Inc PAGE 1 | |RUN TIME: 8:34 AM Accounts Payable | | List G/L Transfers | |-------------------------------------------------------------------------| | | |ACCOUNT SC REFERENCE DATE DESCRIPTION DEBIT CREDIT | |------- -- --------- -------- -------------------- ---------- -----------| | 110000 A Ck 8 03/23/92 SMITH3 Cash 100,000.00| | 110000 A Ck 8 03/23/92 SMITH3 Cash 50,000.00| | 110000 A Ck 8 03/23/92 SMITH3 Cash 8,000.25| | 110000 A Ck 8 03/23/92 SMITH3 Cash 200.00| | 110000 A Ck 8 03/23/92 SMITH3 Cash 90.00| | 110000 A Ck 11 03/23/92 BLANCH Cash 150,000.00| | 110000 A Ck 11 03/23/92 BLANCH Cash 100.00| | 110000 A Ck 12 03/23/92 JONESH Cash 9,899.00| | 110000 A Ck 13 03/25/92 ELECTR Cash 100.00| | ---------- -----------| |Account 110000 Total: 0.00 318,389.25| +-------------------------------------------------------------------------+
After consolidating cash entries per check, the List G/L Transactions will print the following concise report:
+-------------------------------------------------------------------------+ |RUN DATE: 07/10/96 Software Professionals, Inc PAGE 1 | |RUN TIME: 8:37 AM Accounts Payable | | List G/L Transfers | |-------------------------------------------------------------------------| | | |ACCOUNT SC REFERENCE DATE DESCRIPTION DEBIT CREDIT | |------- -- --------- -------- -------------------- ---------- -----------| | 110000 A Ck 8 03/25/92 SMITH3 Cash 158,290.25| | 110000 A Ck 11 03/25/92 BLANCH Cash 150,100.00| | 110000 A Ck 12 03/25/92 JONESH Cash 9,899.00| | 110000 A Ck 13 03/25/92 ELECTR Cash 100.00| | ---------- -----------| |Account 110000 Total: 0.00 318,389.25| +-------------------------------------------------------------------------+
|