Free Spreadsheet Templates

Free Spreadsheet Templates

Free Spreadsheet Templates

How to Start in an Online Business

Phase 2 – Step 10

 

You can view all of my Posts by clicking on the following LinkHelpMeGetMine.com

 

Free Spreadsheet Templates

Create Free Spreadsheet Templates

 

In order for you to start your Bookkeeping each year for your Online Affiliate Marketing Business, you will need to create some new Spreadsheets to use for that new year. If you create Free Spreadsheet Templates for the Spreadsheets that will be needed each year, your new year’s Books will be setup in no time.

The 1st Spreadsheet that you created was for your Business Startup Expenses. Since, you only ‘start’ your business once, this is the only time that you will need to create this Spreadsheet, so no Template is needed.

The 2nd Spreadsheet that you created was for your Fixed Assets & Depreciation. Since, you can add or end Assets in this Spreadsheet continuously, and you will record the dates for when each Asset is first put into service, as well as the dates when they are taken out of service, the same Spreadsheet will be continuously used. Therefore, again, no Template is needed.

 

However, there are many additional Spreadsheets that you will use in your business that will record specific transactions pertaining to each year only. For these, Templates will be created in order to easily set up these Spreadsheets for each year. All of these additional Spreadsheets are as follows:

 

3.  General Ledger

Here is where you will record all daily activity relating to money transactions for your business. This will be like a Checkbook Ledger. You will record both Income and Expenses, and then Copy & Paste the recorded information into other appropriate Spreadsheets.

 

4.  Expenses

This is where you will record all of your Business Expenses that are immediately paid in full, and that are not related to Home Office Operating Expenses or Vehicles Expenses.

 

5.  Home Office Operating Expenses

Here is where you will record all of the Expenses related to operating your Home Office. They will include items like: utilities, internet connection, phone, etc.

 

6.  Accounts Receivable – Income

This is where you will record all of the Income that you receive for your business. It will be a record of the various Affiliate Programs Pay-Outs to you.

 

7.  Accounts Payable

Here is where you will record all of your monthly payments for Business Expenses for items purchased, bills paid, etc., that you purchase or pay for with credit.

 

8.  Vehicle Expenses

This is where you will record all Expenses related to any Vehicles used in your business. You will keep track of mileage, as well as listing Expenses such as: plates, sticker, fuel, insurance etc., and then figure your Percentage of Business Use for each Vehicle.

 

9.  Owner Draws
Here is where you will keep track of monies that you have removed from your Business Account for Personal Income.

 

10.  Retained Earnings

This is where you will keep track of your money after deducting all Expenses from all Income received, as well as any Draws.

 

In time, you will notice that the same entry will be included in multiple Spreadsheets. The reason for this, is that certain Spreadsheets will be used to record your daily activities, while others may only be used at Tax Time to make it easier to complete your Income Taxes. These will not be duplicates of the same entry, but rather a Record of the specific information, organized in a way to assist you in completing a certain task or easily refer to a specific set of Transactions. You will accomplish this easily, by simply Copying & Pasting the information from one Spreadsheet to other appropriate ones.

Then, at the end of each year, these Spreadsheets will be Totaled, Printed, used to help you file your Income Taxes, filed in your Hard Copy File, and then new Spreadsheets will be created to be used for the new year. Therefore, it is best to create Templates so that you can simply Copy & Paste the Templates into new blank Spreadsheets, make a few necessary changes (such as the year entry), and begin using, without the tedious process of creating them all over again from scratch.

 

So, let’s create these Templates now, and also, Copy & Paste each one as we are finished with each, in order to set up this year’s Books. Create them using my Standard Formatting Guidelines as you did for the first two Spreadsheets that you created.

 

3.  General Ledger Template

 

The first Template that you will create will be your General Ledger Spreadsheet Template:

  1. In cell ‘A1’, create your Title:  General Ledger Spreadsheet Template. (Shade:  Turquoise).
  2. Shade cell:  ‘A1’ thru ‘H1’: (Shade:  Turquoise).
  3. In cell ‘A3’, Key in:  Year. (Shade: Yellow).
  4. Expand Column ‘C’ to 30 characters wide.
  5. Expand Column ‘G’ to 15 characters wide.
  6. In the following cell, Key in, Shade, and Center Align, the following Headings:
    • ‘A5’, Key in:  Date (Shade:  Turquoise).
    • ‘B5’, Key in:  X (Shade:  Yellow).
    • ‘C5’, Key in:  Description (Shade:  Turquoise).
    • ‘D5’, Key in:  Type (Shade:  Yellow).
    • ‘E5’, Key in:  Amount + (Shade:  Bright Green).
    • ‘F5’, Key in:  Amount – (Shade:  Red with White Font).
    • ‘G5’, Key in:  Running Total (Shade:  Bright Green).
    • ‘E7’, Key in and Center Align:  Beginning
    • ‘F7’, Key in and Center Align:  Balance

 

3.  Create This Year’s General Ledger Spreadsheet

 

  1. Now that the Template has been created, Highlight & Copy all cells in your Template which contain any Formatting:  namely, cells:  ‘A1’ thru ‘H1’ thru cells:  ‘A7’ thru ‘H7’.
  2. Open a new Spreadsheet and Paste what you Copied from your Template into that new Spreadsheet. Then, Save & Close the Template. File your Template in a properly named Sub-Folder (named:  Spreadsheet Templates) and in the proper Folder (Bookkeeping Folder).
  3. In your new Spreadsheet, click on cell:  ‘A1’’, delete the word ‘Template’ (in the top window), and after Ledger, Add:  a space, a dash, a space, and the current year to the ‘Title. Hit:  Enter (on your Keyboard).
  4. Adjust Column ‘A’ to 30 characters wide, and Column ‘G’ to 15.
  5. Key in the current year in cell ‘B3’. Then, Save, & Close the Spreadsheet.
  6. File your new Spreadsheet for the current year in the proper Sub-Folder (which should be named as the current year, and will be kept in your Bookkeeping Folder).

 

4.  Expenses Template

 

Create your Expenses Spreadsheet Template:

1.  In cell ‘A1’, create your Title:  Expenses Template (Shade:  Red,         with White Font).

2.  Shade cells:  ‘A1 thru ‘R1’ (Shade:  Red, with White Font).

3.  In cell ‘A3’, Key in:  Year.

4.  Expand Column ‘A’ to 30 characters wide.

5.  In the following cells, Key in, Shade, and Center Align, the following      Headings:

    • ‘A5’, Key in:  Expenses (Shade:  Red, with White Font).
    • ‘B5’, Key in:  Type (Shade:  Yellow).
    • ‘C5’, Key in:  Date Paid (Shade:  Turquoise).
    • ‘D5’, Key in:  L. E. (Life Expectancy) (Shade:  Yellow).
    • ‘E5’, Key in:  Method (Shade:  Turquoise).

6.  In Row ‘5’, beginning in cell ‘F5’, Key in all of the months of the year       (going across the Row thru ‘Q5‘), beginning with Jan. and going thru       Dec. (abbreviate months with more than 5 letters).

7.  Beginning with Jan., and every other month, Shade:  Yellow. Then,         Shade the remaining months:  Turquoise.

8.  In cell ‘R5’, Key in:  TOTALS (Shade:  Red with White Font).

9.  Center Align all Headings.

10. Copy cell:  ‘R5’ & Paste into cell:  ‘E20’.

11. Highlight cells:  ‘F20’ thru ‘R20’ (Shade:  Red with White Font).          Also, set Font to 12 pt. for these cells.

12. Using ‘Easy Calculator’, set up Formulas for the following Results:

    • Result for ‘R7’:  Add ‘F7’ thru ‘Q7’ (This will result in a ‘0’ showing in the cell).
    • Result for ‘R20’:  Add ‘R7’ thru ‘R19’ (This will result in a ‘0’ showing in the cell).

13. Change Column ‘R’ to:  12 pt. Font, Centered, and Bolded.

14. Copy cell:  ‘R7’ and Paste into cells:  ‘R8’ thru ‘R19’. Formula              will be Copied.)

15. Copy cell:  ‘R20’ and Paste into cells:  ‘F20’ thru ‘Q20’. (Formula        will be Copied.)

When adding or deleting Rows, Formula will automatically be changed to reflect in your monthly Totals. However, for Column ‘R’, if you add Rows, you will need to Copy one of the cells in that Column, and Paste into your newly added cells in the Column.

 

4.  Create This Year’s Expenses Spreadsheet

 

  1. Now that the Template has been created, Highlight & Copy all cells in your Template which contain any Formatting (in this case, cells:  ‘A1’ thru ‘R1’ thru cells:  ‘A20’ thru ‘R20’).
  2. Open a new Spreadsheet and Paste what you Copied from your Template into that new Spreadsheet. Then, Save & Minimize the Template.
  3. In your new Spreadsheet, click on cell:  ‘A1’, delete the word ‘Template’, and after ‘Expenses’, Add:  a space, a dash, a space, and the current year to the Title. Hit: Enter (on your Keyboard).
  4. Adjust Column ‘A’ to 30 characters wide and Column ‘D’ to 6.
  5. Key in the current year in cell ‘B3’. Then, Save, & Close the Spreadsheet.
  6. File your new Spreadsheet for the current year in the proper Sub-Folder (which should be named as the current year, and will be kept in the Bookkeeping Folder).

 

5.  Home Office Operating Expenses Template

 

Create your Home Office Operating Expenses Template as follows:

1. In cell ‘A1’, create your Title:  Home Office Operating Expenses Template (Shade:  Red, with White Font).

2. Shade cells:  ‘A1’ thru ‘Q1’ (Shade:  Red, with White Font).

3. In cell ‘A3’, Key in:  Year. (Key in the current year in cell ‘B3’.)

4. Expand Column ‘A’ to 30 characters wide.

5. In the following cells, Key in, Shade, and Center Align, the following Headings:

    • ‘A5’, Key in:  Expenses (Shade: Red, with White Font).
    • ‘B5’, Key in:  Actual (Shade: Turquoise).
    • ‘C5’, Key in:  Percentage (Shade: Yellow).
    • ‘D5’, Key in:  Date Paid (Shade: Turquoise).

6. Now, Maximize your Expenses Template.

7. Copy ‘F5’ thru ‘R5’. Now, Minimize your Expenses Template.

8. Paste into cells:  ‘E5’ thru ‘Q5’ in your Home Office Operating Expenses Template.

9. Then, beginning in cell:  ‘A7’, and continuing on down, list all of your known Home Office related Expenses. If you own your home, list:  mortgage interest, home insurance, home taxes, and security system (if you have). If you rent, then list:  rent, renter’s insurance, and security system.

10. Then, skip a Row and then enter all of your utilities (list individually:  gas, electric, water & sewer, garbage, internet, landline phone (if any), etc.

11. Copy cell:  ‘Q5’ & Paste into cell:  ‘D20’.

12. Highlight cells:  ‘E20’ thru ‘Q20’ (Shade: Red with White Font). Also, set Font to 12 pt. for these cells.

13. Using ‘Easy Calculator’, set up Formulas for the following Results:

    • Result for ‘Q7’:  Add ‘E7’ thru ‘P7’ (This will result in a ‘0’ showing in the cell).
    • Result for ‘Q20’:  Add ‘Q7’ thru ‘Q19’ (This will result in a ‘0’ showing in the cell).

14. Change Column ‘Q’ to:  12 pt. Font, Centered, and Bolded.

15. Copy cell:  ‘Q7’ and Paste into cells:  ‘Q8’ thru ‘Q19’. (Formula will be Copied.)

16. Copy cell:  ‘Q20 and Paste into cells:  ‘E20’ thru ‘P20’. (Formula will be Copied.)

 

When adding or deleting Rows, Formula will automatically be changed to reflect in your monthly Totals. However, for Column ‘Q’, if you add Rows, you will need to Copy one of the cells in that Column, and Paste into your newly added cells in the Column.

 

5.  Create This Year’s Home Office Operating Expenses Spreadsheet

 

Now that the Template has been created, Copy & Paste it to a new Spreadsheet, performing the same tasks as for your Expenses Spreadsheet, and storing it in the appropriate Folder. You will also, Save, Close, and Store this Template in the appropriate Sub-Folder and Folder (Spreadsheet Templates).

 

6.  Accounts Receivable – Income Spreadsheet Template

 

The next Template that you will create will be your Accounts Receivable – Income Spreadsheet Template:

  1. In cell ‘A1’, create your Title:  Income Template. (Shade:  Bright Green).
  2. Shade cells:  ‘A1 thru ‘P1’: (Shade:  Bright Green).
  3. In cell ‘A3’, Key in:  Year.
  4. Expand Column ‘A’ to 30 characters wide.
  5. In cell ‘A5’, Key in:  Income Source (Shade:  Bright Green).
  6. Reduce Column ‘B’ to 7 characters wide.
  7. In cell ‘B5’, Key in:  Type (Shade:  Turquoise).
  8. Expand Column ‘C’ to 15 characters wide.
  9. In cell ‘C5’, Key in:  Date Received (Shade:  Yellow).
  10. In Row ‘5’, beginning in cell ‘D5’, Key in all of the months of the year (going across the Row thru ‘O5′), beginning with Jan. and going thru Dec. (abbreviate months with more than 5 letters).
  11. Beginning with Jan., and every other month, Shade:  Yellow. Then, Shade the remaining months:  Turquoise.
  12. Center Align all Headings.
  13. In cell ‘P5’, Key in:  TOTALS (Shade:  Bright Green).
  14. Click on the ‘P‘ to Highlight Column ‘P’ and set Font to 12 pt., Centered and Bolded.
  15. Highlight cells:  ‘C20’ thru ‘P20’: (Shade:  Bright Green). Also, set Font to 12 pt., Centered.
  16. Copy cell:  ‘P5’ & Paste into cell:  ‘C20’.
  17. Using ‘Easy Calculator‘, set up Formulas for the following Results:
    • Result for ‘P7’:  Add ‘D7’ thru ‘O7’ (This will result in a ‘0’ showing in the cell).
    • Result ‘P20’:  Add ‘P7’ thru ‘P19’ (This will result in a ‘0’ showing in the cell). 

18. Copy Cell:  ‘P7’ and Paste into Cells:  ‘P8’ thru ‘P19’. (Formula will be Copied.)

19. Copy cell:  ‘P20’ and Paste into cells:  ‘D20’ thru ‘O20’. (Formula will be Copied.)

When adding or deleting Rows, Formula will automatically be changed to reflect in your monthly Totals. However, for Column ‘P’, if you add Rows, you will need to Copy one of the cells in that Column, and Paste into your newly added cells in the Column.

 

6.  Create This Year’s Accounts Receivable – Income Spreadsheet

 

  1. Now that the Template has been created, Highlight & Copy all cells in your Template which contain any Formatting (in this case, cells:  ‘A1’ thru ‘P1’ thru cells:  ‘A20’ thru ‘P20’).
  2. Open a new Spreadsheet and Paste what you Copied from your Template into that new Spreadsheet. Then, Save & Minimize the Template.
  3. In your new Spreadsheet, click on cell:  ‘A1’, delete the word ‘Template’, and after ‘Income’, Add:  a space, a dash, a space, and the current year to the Title. Hit:  Enter on your Keyboard.
  4. Adjust Column ‘A’ to 30 characters wide,Column ‘B’ to 7 characters wide, and Column ‘C’ to 15.
  5. Key in the current year in cell ‘B3’. Then, Save, & Close the Spreadsheet.
  6. File your new Spreadsheet for the current year in the proper Sub-Folder (which should be named as the current year and will be kept in the Bookkeeping Folder).

 

7.  Accounts Payable Template

 

This Template and Spreadsheet only needs to be created if you have made purchases on credit, with outstanding balances. You will record those Items on this Spreadsheet, as apposed to where you will record the Items which you purchased for cash (recorded on your Expenses Spreadsheet). (If you have no outstanding balances for any Items purchased for your business, then skip this Template and Spreadsheet for now. You can always create these if they are ever needed.)

If you have made purchases on credit, create your Template for this Spreadsheet as follows:

  1. In cell ‘A1’, create your Title:  Accounts Payable Template. (Shade:  Red, with White Font).
  2. In cell ‘A3’, Key in:  Year.
  3. Expand Column ‘A’ to 30 characters wide.
  4. In cell ‘A5’, Key in:  Accounts Payable (Shade:  Red, with White Font).
  5. In cell ‘B5’, Key in:  Pay Type (Shade:  Turquoise).
  6. In cell ‘C5’, Key in:  Date Paid (Shade:  Yellow).
  7. Now, Maximize your ‘Expenses Template’. Copy ‘F5’ thru ‘R5’.
  8. Now, Save & Close your Expenses Template, and file it in the appropriate Sub-Folder & Folder.
  9. Paste into cells ‘D5’ thru ‘P5’ in your Accounts Payable Template.

If you are using the ‘Accrual Method’, payments are recorded when they are due, as well as when they are paid. If you are using the ‘Accrual Method’, you will need to Insert an additional Column before Column ‘C’, which will have the Heading in cell:  ‘C5’:  Date Due.

 

7.  Create This Year’s Accounts Payable Spreadsheet

 

Now that the Template has been created, Copy & Paste it to a new Spreadsheet, performing the same tasks as for your Expenses Spreadsheet, and storing it in the appropriate Folder. You will also, Save, Close, and Store this Template in the appropriate Sub-Folder and Folder (Spreadsheet Templates). Also, Save & Close and Store your Accounts Payable Spreadsheet in the appropriate Sub-Folder and Folder.

If you are using the ‘Cash Method’, you will only record payments as they are made.

If you are using the ‘Accrual Method’, payments are recorded when they are due, as well as when they are paid. If you are using the ‘Accrual Method’, you will need to Insert an additional Column before Column ‘C’, which will have the Heading in cell:  ‘C5’: Date Due.

 

8.  Vehicles Expenses Template

 

Create your Vehicles Expenses Spreadsheet Template:

1. In cell ‘A1’, create your Title:  Vehicles Expenses Template (Shade: Red, with White Font).

2. Shade cells:  ‘A1’ thru ‘U1’ (Shade: Red, with White Font).

3. In cell ‘A3’, Key in:  Year.

4. Expand Column ‘A’ to 30 characters wide.

5. In the following cells, Key in, Shade, and Center Align, the following Headings:

    • ‘A5’, Key in:  Expenses (Shade:  Red, with White Font).
    • ‘B5’, Key in:  Start Miles (Shade:  Turquoise).
    • ‘C5’, Key in:  End Miles (Shade:  Yellow).
    • ‘D5’, Key in:  Total Miles (Shade:  Turquoise).
    • ‘E5’, Key in:  Bus. Miles (Business Miles) (Shade:  Yellow).
    • ‘F5’, Key in:  Actual (Shade:  Turquoise).
    • ‘G5’, Key in:  Percent (Shade:  Yellow).
    • ‘H5’, Key in:  Date Paid (Shade:  Turquoise).

6. Now, Maximize your Expenses Template.

7. Copy ‘F5’ thru ‘R5’. Now, Minimize your Expenses Template.

8. Paste into cells:  ‘I5’ thru ‘U5’ in your Vehicles Expenses Template.

9. In cell ‘A7’, Key in:  Vehicle #1.

10. Leave cell ‘A8’ blank.

11. In cell ‘A9’, Key in:  Year, Make, & Model.

12. Leave cell ‘A10’ blank.

13. In cell ‘A11’, Key in: Start Miles

14. In cell ‘A12’, Key in:  End Miles

15. In cell ‘A13’, Key in:  Total Miles

16. In cell ‘A14’, Key in:  Bus. Miles (Business Miles)

17. Leave cell ‘A15’ blank.

18. In cell ‘A16’, Key in: Payments

19. In cell ‘A17’, Key in:  License Plates

20. In cell ‘A18’, Key in:  Vehicle Sticker

21. In cell ‘A19’, Key in:  Insurance

22. In cell ‘A20’, Key in:  Fuel

23. In cell ‘A21’, Key in:  Maintenance

24. In cell ‘A22’, Key in:  Repairs

If you only use one Vehicle in your business, skip down to Step:  29.

25. If you use more than one Vehicle for your business, leave 3 blank Rows.

26. Then, Copy cells:  ‘A7’ thru ‘A22’ and Paste into cells:  ‘A26’ thru ‘A41’.

27. In cell:  ‘A26’, change text to: Vehicle #2.

28. In cell:  ‘A28’, change text to (the Year, Make, & Model of your 2nd Vehicle).

If you use additional Vehicles in your business, repeat the process as many times as needed.

29. Now, Maximize your Expenses Template.

30. Copy ‘E20’ thru ‘R20’. Now, Minimize your Expenses Template.

31. Paste into cells:  ‘H25’ thru ‘U25’ (or different Row if multiple Vehicles are used) in your Vehicles Expenses Template.

32. Using ‘Easy Calculator’, set up Formulas for the following Results:

    • Result for ‘U7’:  Add ‘I7’ thru ‘T7’ (This will result in a ‘0’ showing in the cell).
    • Result for ‘U24’:  Add ‘U7’ thru ‘U23’ (This will result in a ‘0’ showing in the cell).

33. Change Column ‘U’ to:  12 pt. Font, Centered, and Bolded.

34. Copy cell:  ‘U7’ and Paste into cells:  ‘U8’ thru ‘U23’. (Formula will be Copied.)

35. Copy cell:  ‘U24’ and Paste into cells:  ‘I24’ thru ‘T24’. (Formula will be Copied.)

When adding or deleting Rows, Formula will automatically be changed to reflect in your monthly Totals. However, for Column ‘U’, if you add Rows, you will need to Copy one of the cells in that Column, and Paste into your newly added cells in the Column.

 

8.  Create This Year’s Vehicles Expenses Spreadsheet

 

Now that the Template has been created, Copy & Paste it to a new Spreadsheet, performing the same tasks as for your Expenses Spreadsheet, and storing it in the appropriate Folder. You will also, Save, Close, and Store this Template in the appropriate Sub-Folder and Folder (Spreadsheet Templates).

This Spreadsheet will be used to keep track of all Expenses related to any Vehicles that you use (perhaps in part) for your business. These Expenses will also be tracked separately from your other Expenses, as they will be deducted in a different section on your Income Taxes Forms.

 

9.  Owner Draws Template

 

Create your Owner Draws Spreadsheet Template:

1. In cell ‘A1’, create your Title:  Owner Draws Template (Shade:  Red, with White Font).
2. Shade cells:  ‘A1’ thru ‘E1’ (Shade:  Red, with White Font).
3. In cell ‘A3’, Key in:  Year.
4. In the following cells, Key in, Shade, and Center Align, the following Headings:

  • ‘A5’, Key in:  Date (Shade: Turquoise).
  • ‘B5’, Key in:  Amount (Shade:  Red, with White Font).
  • Beginning in cell ‘C5’, Key in all of the months of the year (going across the Row thru ‘N5‘), beginning with Jan. and going thru Dec. (abbreviate months with more than 5 letters).
  • Beginning with Jan., and every other month thereafter, Shade:  Yellow. Then, Shade the remaining months: Turquoise.
  • ‘O5’, Key in: TOTAL (Shade: Red, with White Font).

5. Using ‘Easy Calculator’, set up a Formula for the following Result:

Result for ‘O7’: Add ‘C7’ thru ‘N7’ (This will result in a ‘0’ showing in the cell).

6. Change Rows 3, 4, & 5 to: 12 pt. Font, Centered, and Bolded.

 

9.  Create This Year’s Owner Draws Spreadsheet

 

Now that the Template has been created, Copy & Paste it to a new Spreadsheet, performing the same tasks as for your Expenses Spreadsheet, and storing it in the appropriate Folder. You will also, Save, Close, and Store this Template in the appropriate Sub-Folder and Folder (Spreadsheet Templates). Also, Save, Close and Store your Owner Draws Spreadsheet in the appropriate Sub-Folder and Folder.

 

10.  Retained Earnings Template

 

Create your Template for this Spreadsheet as follows:

  1. In cell ‘A1’, create your Title:  Retained Earnings Template (Shade: Bright Green).
  2. In cell ‘A3’, Key in:  Year.
  3. Expand Column ‘A’ to 35 characters wide.
  4. For cells:  ‘A3’ thru ‘N3’ thru ‘A31’ thru ‘N31’, make 12pt. Font, Bolded.
  5. In cell ‘A5’, Key in:  Items (Shade:  Bright Green).
  6. Now, Maximize your Income Template. Copy ‘D5’ thru ‘P5’. Now, Minimize your Income Template.
  7. Paste into cells:  ‘B5’ thru ‘N5’ in your Retained Earnings Template.
  8. In cell ‘A7’, Key in:  Beginning Retained Earnings.
  9. In cell ‘A8’, Key in:  Gross Income.
  10. Leave a blank Row.
  11. In cell ‘A10’, Key in:  Sub-Totals.
  12. Leave (3) blank Rows.
  13. In cell ‘A14’, Key in:  Expenses.
  14. In cell ‘A15’, Key in:  Home Operating Expenses.
  15. In cell ‘A16’, Key in:  Vehicles Expenses.
  16. In cell ‘A17’, Key in:  Accounts Payable.
  17. Leave a blank Row.
  18. In cell ‘A15’, Key in:  Net Income.
  19. Leave (3) blank Rows.
  20. In cell ‘A22’, Key in:  Owner’s Draws.
  21. Leave a blank Row.
  22. In cell ‘A24’, Key in:  Ending Retained Earnings.
  23. In cell ‘L23’, Key in:  Year End.
  24. In cell ‘M23’, Key in:  TOTAL.
  25. Shade:  Bright Green the following cells:
    • ‘A7’ thru ‘N7’
    • ‘A8’ thru ‘N8’
    • ‘A10’ thru ‘N10’
    • ‘A23’ thru ‘N23’
    • ‘A29’ thru ‘N29’

26. Shade:  Red, with White Font the following cells:

    • ‘A14’ thru ‘N14’
    • ‘A15’ thru ‘N15’
    • ‘A16’ thru ‘N16’
    • ‘A17’ thru ‘N17’
    • ‘A19’ thru ‘N19’

27. Using ‘Easy Calculator’, set up Formulas for the following Results:

    • Result for ‘N7’:  Add ‘B7’ thru ‘M7’ (This will result in a ‘0’ showing in the cell).
    • Copy cell:  ‘N7’ and Paste into cell:  ‘N8’ (Formula will Copy with the results showing a ‘0’ in this cell).
    • Result for ‘N10’:  Add ‘N7’ and ‘N8’ (This will result in a ‘0’ showing in Cell).
    • Result for ‘N14’:  Add ‘B14’ thru ‘M14’ (This will result in a ‘0’ showing in the Cell).
    • Copy cell:  ‘N14’ and Paste into cells:  ‘N15’, ‘N16’. ‘N17’, & ‘N27’.
    • Result for ‘N19’:  Add ‘N14’ thru ‘N17’.
    • Result for ‘N23’:  Subtract ‘N10’ minus ‘N19’ (This will result in a ‘0’ showing in the cell).
    • Result for ‘N29’:  Subtract ‘N23’ minus ‘N27’ (This will result in a ‘0’ showing in the cell).
    • (Cell ‘N28’ will not have an entry. It is blank.).

28. Copy cell:  ‘N10’ and Paste into cells:  ‘B10’ thru ‘M10’. (Formula will be Copied).

29. Copy cell:  ‘N19’ and Paste into cells:  ‘B19’ thru ‘M19’. (Formula will be Copied).

30. Copy cell:  ‘N23’ and Paste into cells:  ‘B23’ thru ‘M23’. (Formula will be Copied).

31. Copy cell:  ‘N29’ and Paste into cells:  ‘B29’ thru ‘M29’. (Formula will be Copied).

(This will temporarily show results as a ‘0’ in cells until actual figures are Keyed in.)

 

10.  Create This Year’s Retained Earnings Spreadsheet

 

Now that the Template has been created, Copy & Paste it to a new Spreadsheet, performing the same tasks as for your Expenses Spreadsheet, and storing it in the appropriate Folder. You will also, Save, Close, and Store this Template in the appropriate Sub-Folder and Folder (Spreadsheet Templates).

 

If you do not have any Employees, then these are the only Spreadsheets that you will need for your Books right now. Save & Close any remaining open Spreadsheets and Templates and file them in the appropriate Sub-Folders and Folder.

If you do currently have Employees then continue on to create the needed Templates and Spreadsheets.

 

11.  Payroll Expenses

 

These Templates and Spreadsheets only need to be created if you have Employees. If you have no employees, then skip this section. If you have Employees, you will need several different Templates and Spreadsheets to complete your Payroll process:

1. Employee Information

This Spreadsheet shows a list of all of your Employees, along with their Hourly Wages, their chosen W-4 Deductions, and more.

2. Weekly Time Card

This keeps track of the Employee’s daily work hours for a given week.

3. Paycheck Calculator

This will show weekly: Gross Amount, Federal, Soc. Sec., and State Deductions, as well as any other applicable Deductions, such as, Insurance, 401-K, etc.

4. Federal & State Deductions

You will use this to keep track of the amounts that you deduct from each paycheck for Federal, Soc. Sec., and State Tax Deductions, so that you can send in quarterly payments to the appropriate government agencies.

 

Depending on how your Employees are treated by you, you may need some additional Spreadsheets:

    • Vacation Accrual
    • 401-K Accounts
    • Travel Expenses
    • Profit Sharing

 

Since, you are just starting your Online Affiliate Marketing Business, chances are that you are the only Employee of your company, so I will not get into all of these at this time. However, bear in mind, that if and when you decide to have any Employees, that there are many things involved in order to keep track of all of the various Employee Payments and Deductions.

If you intend to hire writers to write some of your Posts, for example, you may want to consider paying them as free-lance self-employed contractors, and pay them on a per job basis. This will make your Bookkeeping much easier, as all you will need to track is your individual Gross Payments, without all of the Payroll Deductions and Benefits involved with handling Hourly Employees. You will issue each of them a W-9 at the end of the year showing them the Gross Wages that they earned and they will be responsible to pay their own self-employment Taxes.

 

OK. Great Job!

All of Your Bookkeeping is Set Up and Ready To Go!

 

Please leave a Comment or ask a Question in the Comments section below.

 

In the next post, I will go over each Spreadsheet that you have created and list what Items need to be placed where in each Spreadsheet. You can simply skim through it, and refer to that post whenever needed. See my PostHow to Work With Online Business Spreadsheets.

 

Thank you,

CJ Dodaro

 

Be Sociable, Share!

About Author

CJ Dodaro
I am a semi-retired, 65 year young man who has owned and operated a variety of successful business throughout my life. Starting most from scratch, I have acquired extensive knowledge for what is required for setting up a business properly from the ground up. Since these businesses have been both the brick & mortar type as well as the online variety, I feel qualified to help people in almost any business area that they wish to pursue. I wish to share the information that I have acquired in order to help other aspiring entrepreneurs become successful.

Leave a Comment

Your email address will not be published. Required fields are marked *