www.bigez.com | About Us. © 1996-2015 | Testimonials | Subscribe to Our Newletter | Privacy Policy | Refund Policy | Contact

Big EZ Bookkeeping

The Clear and Concise Way to Keep Your Books!

Getting Started Guide for Mac

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
         locked down.

     ●  The category titles in the light yellow boxes  can be changed in the Period 1 (January)
          only.

     ●  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
         mid-year.

     ●  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
                     balance.

         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

Here's How...


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.