coglog
Services Limited
 
Integrated Business Solutions

LEDGER REPORTS

8PLP01M- REPRINT BATCHES

PLP01

Enter and Y to confirm.
Results are displayed - Enter for more or Esc to exit.

8PLP01M1 - Reprint Batch

                                               ----- Variance -------
Account Per Desc    Batch Ref.      Trans    Master Credit        Debit    Qty

680000  5   A/cName REF   100002     856.30-         856.30        856.30
680000  7   A/cName REF   100004     856.30-         856.30         16.67
680000  8   A/cName REF   100006   1,000.00-       1,000.00        856.30
680000  9   A/cName REF   100007   1,866.92-       1,866.92        300.00
680000 10   A/cName REF   100008     621.90-         621.90      1,000.00
680000 13   A/cName REF   100009     258.54-         258.54        258.54
...
8PLP01M2 - Reprint Batch with Detail

Batch   Per   Account    Date   Ref.     Source         Value    Description                      Text

CR0742   6      680000  7/09/03 CBL04                    659.27- National Bank 023741-2378232-33  Creditors Payments
                                      Batch Totals       659.27-                      659.27           .00

DT0114   6      680000 30/09/03 CBL04                    523.13  National Bank 023741-2378232-33  Debtors Payments
                                      Batch Totals       523.13                          .00        523.13

XXXX     6      680000  6/09/03 XXXX                       1.00- National Bank 023741-2378232-33  ON-LINE FEE
                680000 27/09/03 XXXX                       3.75- National Bank 023741-2378232-33  CHARGES
                680000 30/09/03 XXXX                      49.40- National Bank 023741-2378232-33  MORE CHARGES
                680000 30/09/03 XXXX                     277.79- National Bank 023741-2378232-33  INTEREST
                680000 30/09/03 XXXX                  10,000.00  National Bank 023741-2378232-33  LOAN NNN
                                      Batch Totals     9,668.06                       331.94     10,000.00
...

8PLP02M- Posting Reports

See Running Reports for running all the following.
Prints Opening Balances and postings for the selected accounts and period ranges.

8PLP02M1
                                                                      For periods 01 to 15  Format POST   Date:  7/10/09

Account   Period  Date   Batch / Ref.      Text                              Debit        Credit     Open. Bal      Closing Bal.


    301-001      Advertising & Promotions - Product           Opening Balance                              0.00
              5 14/08/09 0000101319    MISC     Advertising & Promoti        444.44
                                                                   Period 05:                            444.44          444.44
             14 19/05/09 THEMIL        MISC     Advertising & Promoti         51.53
                                                                   Period 14:                             51.53          495.97
                                                           Postings & Balance                            495.97          495.97
                                                         Run totals                                                        0.00

8PLP02M2 - Postings Report with Period Subtotals
                                                                      For periods 01 to 15  Format POST   Date:  7/10/09

Account       Description                                                                               Open. Bal      Closing Bal.
       Period  Date   Ref.     Batch  Ref 2        Text                                       Debit / Credit


    301-001  Advertising & Promotions - Product                                  Opening Balance               0.00
           5 14/08/09 OBORNS   CR1787     101319   MISC     Advertising & Promotions - Pr       444.44
                                                                                      Period 05:             444.44        444.44
          14 19/05/09 THEMIL   CR2106              MISC     Advertising & Promoti                51.53
                                                                                      Period 14:              51.53        495.97
                                                                              Postings & Balance             495.97        495.97
                                                                                       Run total                             0.00
8PLP02M3 - Postings Report with Difference
Includes the differences between entered and calculated values when Split to is used.
                                                                      For periods 01 to 15  Format POST   Date:  7/10/09

Account   Period  Date   Batch / Ref.      Text                            Posted     Origional    Difference     Calculate      Z


    301-001      Advertising & Promotions - Product      Op Balance
              5 14/08/09 OBORNS CR1787 MISC     Advertising & Promoti       444.44        500.00         55.56         55.55 *

             14 19/05/09 THEMIL CR2106 MISC     Advertising & Promoti        51.53         57.97          6.44          6.44 *
                                                             Totals         495.97        557.97         62.00         61.99
                                                         Run totals         495.97        557.97         62.00         61.99
8PLP02M4 - GST Postings Audit Reports differences between Expected and Actual GST calculations from original Supplier Invoice.
                                                       Per: 01 to 15 Format POST  Date:  7/10/09

Period  Date   Batch / Ref.      Text                    Posted        GST      Calc.     Diff.


    301-001      Advertising & Promotions Op Balance        0.00
  5 14/08/06 OBORNS CR1787 MISC     Advertising & Pr      444.44      55.56      55.55      .01

 14 19/05/07 THEMIL CR2106 MISC     Advertising & Pr       51.53       6.44       6.44
                               Totals                     495.97      62.00      61.99      .01

                           Run totals                     495.97      62.00      61.99      .01
8PLP02E1 - Postings Export
Can be used for any account but designed specifically to import the Bank account directly into a spreadsheet. The report includes opening, closing and movement totals. The "Tp" (type) column contains an alphabetical aid to assist sorting the report while keeping with the Totals in their own rows.

 Tp	Account	Prd	date	ref	text	trans $	subt $	Opening	Movement	Closing


8PLP03M1 - Actual / Budget - Variance %

                                            --- c u r r e n t   p e r i o d ---   --- c l o s i n g   b a l a n c e ---
                                              ACTUAL         BUDGET    VARIANCE        ACTUAL        BUDGET    VARIANCE

8PLP03M2 - This Year / Last Year - Variance $

                                           ---- c u r r e n t   p e r i o d ----   --- c l o s i n g   b a l a n c e ---
                                             Last year      This year   Variance     Last year      This year   Variance

8PLP03M3 - P/L General Report

                                               Period Movement      B  A  L  A  N  C  E

8PLP03M4 - Chart of Accounts

Includes Close To , Report Codes and Alpha Codes .
If more than one Split To is present they are reported on the following line.
The final code is a Change To if present.

 Account      Close-to    Description                               Report Codes....  Alpha        Split-to

    200 001        999000 ACCOUNT                                   11 22 33 44 55 66 A/C                              966000
                  486000 ENT      911000 GST
    200 004        999000 ACCOUNT                                   11 22 33 44 55 66 A/C              486000 ENT      967000

8PLP03M5 - Trial Balance

                                              - c u r r e n t   p e r i o d -   - c l o s i n g   b a l a n c e -
                                                    Debits          Credits           Debits          Credits

8PLP03M6 - Current Period + Balance each with Dr, Cr, and Ratio

                                               -- C u r r e n t   P e r i o d --    -- C l o s i n g   B a l a n c e --
                                                      Dr             Cr      Ratio         Dr             Cr      Ratio

8PLP03M7 - 4 columns with Current Period and Ratios.

                                         Period Movement      B  A  L  A  N  C  E              Budget + Var.    Ratio

8PLP03MB - M1 with Budget and Variance $

                                            --- c u r r e n t   p e r i o d ---   --- c l o s i n g   b a l a n c e ---
                                              ACTUAL         BUDGET    VARIANCE        ACTUAL        BUDGET    VARIANCE

exports

8PLP03E4 - Actual, Budget, Variance %

      * Format:    ASCII, Comma-delimited, Quotes
      * Output:    Desc,
      *            (Period) Actual, Budg, Var %, Var $,
      *            (Balance) Actual, Budg, Var %, Var $,
      *            A/c Code,
8PLP03E6 - Published accounts
      * Format:    ASCII, Comma-delimited, Quotes
      * Output:    Desc,
      *            (Balance) This Year, Last Year,
8PLP03EB - Actual, Budget, Variance $
      * Format:    ASCII, Comma-delimited, Quotes
      * Output:    Desc,
      *            (Period) Actual, Budg, Var $,
      *            (Balance) Actual, Budg, Var $,
      *            A/c Code,

8FRP02 - Print Report Format

Report/Seq/Type

01 Select     Col  Tot  If    Ranges
02 Total      Col  Tot  To    Desc.

ACP    100 99A S D Y          Accounts Payable Check
ACP    200 01  1   1   N       870000     870000