Modify Your Free Spreadsheet: Manual Accounting Reports

Look at the bottom tabs...click on the brown tab named “Jan”.

Modify Fund Accounts:

Delete Columns (Businesses):

1. To take out one business: Select column headings H & I and delete.
2. Formulas automatically adjusted. Repeat for remaining months.
3. Go to Annual Report, select column H & I to take out one business. Formula adjusted.

Add Columns (Businesses) to the Monthly Report :

1. To add 2 more businesses, select columns E-H, click insert.
2. Select columns I-L, click copy.
3. Select column E, hit enter.
4. Rename businesses and select different font colors.
5. To add 1 column (business), do steps above but select only columnsE & F.
6. Repeat for remaining monthly reports.
7. The annual report is a little more difficult to modify with additional columns, see the steps below for adding more businesses to the Annual Report.

Add Columns (Businesses) to the Annual Report :

1. Do steps 1-4 above.
2. Now...since this is a view-only sheet...you are going to have to reset some formulas
3. Select cell D11. Grab the Fill Handle and pull across to cell L11.
4. Select cell D12. Repeat step 3.
5. Select cell D16. Repeat step 3.
6. Repeat for every expense line item in column D.
7. Now to get rid of the formulas in the blank columns: Select cell E11, hold down on your button and highlight cells in column E down to cell E23, press delete on your keyboard.
8. Repeat for columns G, I, & K.
9. If you don’t like the solid dividing line in rows 12 &23, you can break them up by selecting cell E12,on the Home tab, in the Font group, click on the borders icon arrow, choose No Border, go down to E23, select and just click on border icon (the no border should still be showing).
10. Repeat for the rest of the blank columns.

Modify Line Accounts (Revenue, Expenses, etc.):

Go back to January’s monthly report.

Delete Rows (line accounts):

1. To delete one of the two income line accounts in the BA3BizManual free spreadsheet, simply select row 11, click delete.
2. To delete one or more of the expense accounts, simply select row 17, (highlight as many rows as you want to delete), click delete.
3. Repeat above steps for remaining monthly reports and annual report.

Add Rows (line accounts):

1. To insert one or more rows in the income line accounts, simply select row 12, click insert for as many rows as you want to add.
2. Select first cell in total column, grab hold of the fill handle and pull down to last income account line.
3. To insert one or more of expense accounts, select row with second expense account and click insert for as many rows as you want to add.
4. Repeat step 2.
5. Repeat above steps for remaining monthly reports.
6. Adding rows (line accounts) in a little more difficult in the annual report:
7. Repeat steps 1 and 2 to add more income accounts.
8. Select cell D12.
9. Grab hold of the fill handle and pull down to fill out new income accounts.
10. Repeat for each business.
11. Repeat step 3 to add the required expense accounts.
12. Select first cell in business #1 column, grab hold of the fill handle and pull down to fill out new expense accounts.

Whew! We’re finished! If I missed anything in modifying this free spreadsheet, please contact me.

Return to BasicAccountingHelp’s Home Page from Free Spreadsheet