I should note that when I created the corporation, I bought 100 shares of stock, and loaned the rest to the company for startup. I’ve attached it but first replaced all specific names with generic ones, etc. As my invoices were monthly or project ‘milestone’ based, they were few in number per year. At the bottom was a continuous profit & loss statement as well as full balance sheet. I manually calculated payroll numbers and had columns for each accrual account. I used separate columns for everything with the cash account a single column with both debits and credits, then posting the opposite side in an appropriate column. As I had 2 semesters of accounting in college in the late ’60s, I set up a rudimentary full-year bookkeeping spreadsheet using Lotus 1-2-3 and later, Excel. Although I had plans, it never progressed beyond just myself. 2) HOW knowledgeable are you in accounting? 3) Do you know how to use ACCESS to extract data from an Excel spreadsheet and create reports?įor what it’s worth, back in 1982, I created my own sub-chapter S corporation to do computer consulting. Three questions immediately come to mind: 1) HOW knowledgeable are you in Excel? You many need to know various builtin functions as well as have the ability to create your own sorting functions, etc. This topic was modified 2 years, 11 months ago by dmt_3904. Is anyone using Excel in for keeping finances? How are you doing it? What template are you using, if any? How are you doing monthly reconcile of accounts? I know it won’t be as nice as Quickbooks, but I am hoping I can make it work for my simple needs. I’ve checked a few of the budget templates, but none of them seem what I am looking for. (And btw if you use those products, are you aware that your bank will not support you if there is a breach and your account is hacked- you are on your own!) I am not willing to give up my bank account passwords to them or any third parties. I am also aware that there are many other financial software providers out there (like Mint). Run reports – of course will not have the robust reports that QB has.Create accounts to sort income & expenses.Download credit card transactions (can download in excel).I am not always happy with Intuit, but it’s a huge software corporation, just like Microsoft – replete with problems! I need to perform these functions: It’s great software! Very functional and feature-rich. We no longer have a business and I no longer want/need to pay for QB. I have been a Quickbooks user for many years.