CERTIFIED GENERAL ACCOUNTANT

 

Home

Meet Your Accountant

Accounting News

Income Tax News 

Client Solutions

Links & Tips

Contact Us

    

Client Solutions

Do your own bookkeeping on an automated synoptic spreadsheet

Are you one of those clients who's business is not big enough to hire a bookkeeper, but small enough to do your own entries?  Do you know how to use Microsoft Excel?  If so, download this spreadsheet and simply fill one of these out for each month.

synoptic.zip (Excel version 2003 94.3 KB)

Your business is not big enough to do entries?

Download the following excel spreadsheet and accumulate your receipts in categories for the year (not monthly).  The spreadsheet is linked – just click on the category to open that category.  To return to the summary click on “Totals”.

 

breakdown.zip (Excel version 2003 20.6 KB)

How Much Interest Did You Pay On Your Loan?

Here's a spreadsheet done up with adjustable entries to figure out how much interest was paid, when the loan will be paid off, and what the carrying value will be at any point in the duration of the loan.

loanamort.zip (Excel version 2003 29 KB)

 

 


Copyright © 2008 Bolognese & Co., All Rights Reserved.
This website is hosted by
Paradox Web Hosting. "Into Tomorrow Today!"