Combining Methods For Printing Budget Figures

 

This final example combines many of the codes and methods available for printing financial reports. This report compares budget and actual figures between two different years. Although this is just an example, it may give you some ideas for setting up your own financial report print parameters.

The print parameters were set up as follows:

images\method_8_(budget)_sample_shg.gif

The reference point for all of the codes is January 2002.

  • Column 1 will show budget figures for the period beginning 01/02 (0 months from the Current Period Begin date) and ending 12/02 (11 months from the Current Period Begin date).

  • Because of the “4” entered into the Pct field, the system will calculate the net change ratio between column 4 and column 1: (Column 4 - Column 1) ÷ Column 1.

  • Column 2 will show actual figures, excluding year-end entries, for the period beginning 01/12 and ending 12/12.

  • Column 3 will show the difference between column 2 and column 1 (actual minus budget).

  • Column 4 will show budget figures for the period beginning 01/13 (12 months from the Current Period Begin date) and ending 12/13 (23 months from the Current Period Begin date).

  • Column 5 will show the difference between column 4 and column 2 (2013 budget minus 2012 actual).

The final report will appear as follows:

                                                             BUDGET        4-1/1         PERIOD              COLUMN               BUDGET             COLUMN

                                                       ENDING - 12/13       PCT        1/12 - 12/12           2 - 1         ENDING - 12/14            4 - 2

                                                       -----------------   ------   -----------------   -----------------   -----------------   -----------------

              INCOME

     111-00    INT INCOME / SIGNATURE LOANS PART SECU         316,090.92-   100.0-%        835,445.18-         519,354.26-                .00        835,445.18

     111-01    INT INCOME - BUSINESS REAL ESTATE PART                .00       .0 %          4,005.21-           4,005.21-                .00          4,005.21

     111-02    N/A                                                   .00       .0 %               .00                 .00                 .00               .00

     111-03    INT INCOME - SHARE PLEDGE LOANS                       .00       .0 %         26,003.86-          26,003.86-                .00         26,003.86

     111-04    INT INCOME - SIGNATURE LOANS                 1,839,922.92-   100.0-%        941,036.99-         898,885.93                 .00        941,036.99

     111-05    INT INCOME - STOCK LOANS                              .00       .0 %               .00                 .00                 .00               .00

     111-06    INT INCOME - PAYMENT SHAVER LOANS                     .00       .0 %               .00                 .00                 .00               .00

     111-07    INT INCOME - PAYMENT SHAVER USED                      .00       .0 %               .00                 .00                 .00               .00

     111-08    INT INCOME - BUS ADJ RATE MORTGAGE             181,186.92-   100.0-%         62,760.30-         118,426.62                 .00         62,760.30

     111-09    VIP LOAN INTEREST REBATES                             .00       .0 %        159,314.71          159,314.71                 .00        159,314.71-

     111-10    PAYMENT SHAVER PREMIUM                                .00       .0 %               .00                 .00                 .00               .00

 

 

Related Topics

Method 1 - Using Report Type Codes

Method 2 - Using the "Begin" and "End" Fields

Using the "Begin +/-" and "End +/-" Fields for Reporting Budget Periods

Using "Math +/-" Calculations

Using "% Val" Percentage Calculations

Using "Pct" for Percentage of Gross Income

Using "Pct" for Net Change Ratios