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:
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 "% Val" Percentage Calculations
Using "Pct" for Percentage of Gross Income
Using "Pct" for Net Change Ratios