Modify Your Free Excel Spreadsheet - Manual Accounting

• SAVE an original copy.
• Look at the bottom tabs.
• Click on the first tab named “GL-Jan”.

Adding or Deleting Businesses:

Delete Business Columns on the 3Biz Manual Free Excel Spreadsheet :

1. Select the columns that you want to delete. (Click on the letter of the columns you want to delete and hold the left button on your mouse and highlight all columns you want to delete)If you are just taking out 1 column, you would highlight columns I-L.
2. You can either right click and click on Delete, or...on the Home tab, in the Cells group, click the drop down arrow next to Delete, and then click Delete Sheet Columns.
3. Now correct your formulas in the balance column: select (click on) the last cell in row 5.
4. Click the F2 button on your keyboard, select the #REF!+ for all the fund accounts you took out in the cell formula, click delete, then enter on your keyboard.
5. Select the last cell in row 9, click F2, select the -#REF!+#REF! for all the columns you deleted, click delete, then enter.
6. Select the last cell in row 9 again, click F2. Your formula should now be the total beginning balance (last cell in row 5) minus all the expenses in row 9 plus all the incomes in row 9 (not necessary to be in that order)
7. Select the last cell in row 10, and follow directions in step #5.
8. Select the last cell in row 10 again, Notice the little black box on the bottom right corner of that cell. That is your “Fill Handle”. Put your mouse pointer over it. Notice how the pointer goes from a fat white plus sign to a skinny black plus sign. That means your fill handle is ready. Click and pull down to the last cell in row 33.
9. Select the last cell in row 35. Follow instruction in step#4. Your formulas are now set.

Add Business Columns on the 3Biz Manual Free Excel Spreadsheet :

1. For each business you want to add...you will need to insert 3 columns.
2. To insert multiple columns, select the columns immediately to the right of where you want to insert columns. Select the same number of columns as you want to insert.
3. For example, say you wanted to add 2 additional businesses You would select columns I-N and either right click and click on Insert or...on the Home tab, in the Cells group, click the arrow next to Insert, and then click Insert Sheet Columns.
4. Then highlight (select) columns O-T, click copy, select column I, and hit enter.
5. Rename businesses and select different font color.
6. Set formulas: select the last cell in row 5 (beginning balances),hit F2, hit the plus sign on your keyboard, then click on cell for the new business, repeat for additional businesses, and/or hit enter to set formula.
7. Select the last cell in row 9, click F2, hit minus J9 plus K9 minus M9 plus N9, click enter to set formula.
8. Repeat step 6 for next balance cell in row 10 except it will be – J10 + K10 – M10 + N10.
9. Select the last cell in row 10 again, grab fill handle and pull down to the last cell in row 33.
10. Select last cell in the balance column (yellow box) and hit F2, click the plus sign on your keyboard, then click on the monthly balance cell in row 35 for the new business, click + for additional businesses, and/or hit enter to set formula.
11. Repeat above steps for each month in your workbook

Now you need to fix your monthly reports and annual report to match you general ledger.

Click here for instructions on modifying your reports in the manual accounting free excel spreadsheet.

Note: See manual accounting instructions for adding and deleting rows in your free excel spreadsheet - Manual Accounting.

Return to BasicAccountingHelp’s Home Page from Modifying Your Free Excel Spreadsheet