Automatic AccountingSpreadsheet Instructions

First: Personalize

• SAVE an original copy.
• Look at the bottom tabs.
• Click on the first red tab named “GL-Jan”.
• Click on the merged cells with “Name” typed in - Row #1.
• Type in your business’s name-(All you “set up” on this first sheet will auto fill in the rest of the months’ general ledger worksheets).
• Type in correct year if needed. Will need to repeat for each month and the annual report.
• Type in business names if using 3Biz Automatic Accounting spreadsheet.
• You can now delete or add extra columns or rows. See how to modify your spreadsheet.
• Put in beginning balance(s)-Row #10 (Jan GL)(*Even though you will probably be starting in another month...the balance(s) will carry forward)
• Rename Revenue and Expense Accounts- (The first 3 are “Revenue Accounts”. The remaining accounts are Expense Accounts. (You only have to do this once...all the remaining general ledgers and reports will auto fill).
• Look at the bottom tabs...click on the brown tab named “Jan” This is a view only sheet! Once you type in the following information...you will not need to do anything else. It will automatically generate reports from the general ledgers.
• Click on “ Name” in the second worksheet (Row #2).
• Type in your business’s name - (All you “set up” on this first report will auto fill in the rest of the reports)
• Type in the name of the report- Row #3-(This is an Income Statement. You can name it whatever you want though.).
• Type in correct year if needed. Will need to repeat for each report.
• Type in business names if using 3Biz Workbook-Row #8 and Row #9.
• SAVE one more copy! This one will be your original to use every year. Can delete original one not personalized now.

Begin to use!

• Revenue will be entered under its corresponding account in the credit (Income) column. (First 3 accounts are Revenue Accounts).
• Advertising, office supplies, payroll, etc, will be entered under its corresponding account in the debit (Expense)column. (All remaining accounts are Expenses Accounts).
• Don’t worry if you accidentally delete a formula in the general ledgers. Just click the “Go Back Button”.

*Notice: When you put an entry in the general ledger...it automatically updates the reports.

**Remember once you personalize the spreadsheets you will ONLY be entering data in the general ledgers. The report spreadsheets are View-Only - (Data is automatically entered)!

Other pages that may interest you:

Go to Basic Accounting Concepts from Automatic Accounting Spreadsheet Instructions