Basics of the Big E-Z Bookkeeping System
You enter data in only 3 tabs: Deposits, Checks, and Cash&Charges. (Note: The other tabs are automatic reports requiring no data entry on your part, with the exception of two optional tabs: Account Balance Tracker─highly recommended─and the Budget Calculator.)
● There are 12 monthly files and a year-to-date summary in the Big E-Z System.
● To access the worksheets click one of the 10 tabs below.
● Enter data in white boxes throughout the worksheets. All shaded areas are intentionally
● The category titles in the light yellow boxes can be changed in the Period 1 (January)
● The color-shaded cells are intentionally locked and if you click on them you will get a
message saying "The cell or chart you are trying to change is protected...".
● Data entered in the dotted sections will not affect the IncomeStatement.
● Categories and repeating transactions entered in Period 1 (January) will populate on
each of the monthly workbook file and the summary.
Note: Do NOT make changes to the categories and repeating transaction descriptions
● Tip: Keep receipts organized using the receipt storage book. Label the envelopes with
expense categories that match your category groups (see Settings tab).
Setting It Up
Step 1: Go to the purple Settings tab and change the name (upper left) to something
more meaningful to you.
Step 2: The program is set up for a calendar year. If you follow a fiscal year, set the
first month as your Period 1. Then change the rest of the months.
Step 3: If desired, switch to the European date format.
Step 4: Decide on a Category Group for this account: Business, NonProfit, Personal
or Customized. Each Category Group allows for customization either on the
Settings tab or in Period 1 (January) Deposits and Checks.
Step 5: Optional. Set up repeating transactions. Do a little research to determine
which transactions occur each month and set up the transaction description in
the Deposits, Checks, Cash&Charges and Account Balance Tracker
worksheets. Note: Only the description repeats. Dollar amounts need to be
entered each month. If you do not plan to use this feature just bypass it and
start entering data on Row 18. Some common examples include: rent or
mortgage with due date, loan payments, and utility bills.
Step 6: Optional Budget Calculator: Go to the purple Settings tab and click on the
Summary file found at the bottom of Step 2. Next click on the brown Budget
Calculator tab and enter budget amounts in Column D.
Now you are ready to start entering data
Save often and backup your data to an external device such as a flash drive. Click
on Show Help (on top left of each page) for detailed instructions for each worksheet.
Step 1: Click on the green Checks tab (lower left) and enter last month's bank
Step 2: Click on the gold Deposits tab (lower left) to open the Deposits worksheet
and enter all different types of income for the month.
Step 3: Click on the green Checks tab and enter checks written, bank debits, cash
withdrawals, transfers to other accounts for the month and expenditures
using PayPal. This will provide the majority of the data. Record cash, credit
card expenditures and mileage Click the aqua tab for Cash&Charges and to
enter these non checkbook expenditures.
Now You Can Import Data to the New 2013 System
Step 1: Download your banking data as a CSV file and open it with Excel.
Step 2: Remove any unnecessary columns (highlight and cut). Remaining columns must
include: Date, Description, and Amount, in that order.
Step 3: If necessary, sort the data by checks and deposits, or charges and payments.
Step 4: IMPORTANT STEP. Highlight and copy columns over to Notepad (to remove formatting)
Step 5: Close the CSV file after saving your changes.
Step 6: From Notepad, highlight and copy columns into the Big E-Z System starting on Row
18, Column A.
Step 7: Categorize (and subcategorize) your entries.
Note: You may need to repeat this for Deposits, Checks and Cash&Charges.
At the end of the month
Step 1: Click on the navy blue tab to reconcile the checkbook with your bank
statement and prove your records are accurate.
Step 2: This is also the time you can update other accounts such as savings or
investments by entering monthly or quarterly items (e.g. gains or losses,
interest or dividends) directly onto the Deposits worksheet. These totals
will then transfer over into the Account Balance Tracker. NOTE: if you have more than one Investment account, Savings account, Shopping Cart
account, or more than one Credit Card, you will need to break these down
on the Account Balance Tracker every month. See Show Help on Account
Balance Tracker for more details.
And you're done!
WARNING The data (you enter) and software (we provide) in this program are one in the same. If you use the uninstall option or you delete any of these files or fail to backup your data properly YOU WILL LOSE YOUR DATA. You would need to re-install and RE-ENTER YOUR DATA. No updates will be issued. You must register to receive program news or notices.
Back-Up Your Data Often
Do NOT move, rename, copy or delete the Big E-Z tabs, charts or files.
Disclaimer This software will help you summarize your data for the year, but year-end adjustments may be needed. You should seek the advice of an accountant or tax preparer if your personal situation warrants it.
File Location To open a different month go back to the Settings tab from any file, then click on a new period along the top left. The arrow points to the month you currently have open. Your Big E-Z folder in located in your documents folder.
Maintenance There are 12 monthly workbooks and one year-to-date summary workbook for your 2013 records.
SAVE and back up your work often! As you complete each month, print and store your monthly reports in a binder.
Print the Worksheets Use our Print Report buttons located at the top left of each worksheet. Remember to PREVIEW PRINT report before printing---so you print only the pages you need.
Print a Specific Area of the page, highlight the area to be printed then click File, Print Area, Set Print Area, then click Print Report button.
Run Time Errors Excel Run Time Errors can occur for many reasons. If you have a combination of workbooks open from different Excel versions you may come across a Run Time Error. It is very important NOT TO SAVE YOUR WORK if you are presented with a Run Time Error, especially if you are missing the tabs along the bottom of the worksheet. Instead close out of the monthly file (workbook) without saving change. Now, re-open the workbook and re-enter your data from the last time you saved. It's another great reason to Save Your Work often.
Subcategories & 1099 Totals (Optional-purple area on far right side of Deposits & Checks) These records can be printed only from the Summary file.
Support Use our Show Help Buttons located on top of each worksheet for help while entering data. No manual is included. Click the Big E-Z logo link near the top left of this page to visit our website or go to www.bigez.com. If we cannot resolve your issues by email, we may need to schedule a remote session with you.
Please Note: Big E-Z Software has been tested on a Mac with Excel 2011 installed. It has been duly noted that a Run-time error message displayed in testing but in no way changed the integrity of the system. Just close out of the message and continue using. It was also noted that a file-save dialogue appears when trying to save. Just continue to save the file as an xls file.