I need to do something different for 2017. You might find a solution here for your 2017!
So in the meantime I wondered why not just use a spreadsheet.
The graphic above is a screenshot of my new bookkeeping system using Google Sheets. This would work in Excel, Numbers, and others. The screenshot was taken on my phone. I'm thinking my bookkeeping entries will be made from my phone, tablet or laptop. Very convenient. 'Anywhere Bookkeeping'! Click to download my spreadsheet.
- Date - transaction date
- Payer/Payee - vendors and clients, could be separate, but can't see why yet
- Income - incoming cash, could be combined with Expense, but the you have to remember the minus sign
- Expense - outgoing cash
- Project - 'General Office' will get most expenses, but I want to explore 'chargeable' time for Project Profit/Loss
- Category - basically Schedule C tax categories plus others that make sense
- Description - more information to make sure you know what the entry is for
- Paid? - this lets you enter a bill when you get it or an invoice when you send it, but tag it NO so you can find your accounts payable and accounts receivable
- Billable? - reimbursable expenses
- Projects - this is a referenced list of project names
- Exp Categories - this is a referenced list of expense category names
- Payer / Payee - this is a referenced list of payor and payee names
- Description - this is a referenced list of descriptions for convenience
Those last four columns are used so that the same spelling is always used. This will allow filters to work. The name-related column has a pull down list with these names. To separate payers from payees, I start payers with a hyphen, e.g. "-Mr. Project Client". The hyphen will put all payers at the top of the list when you sort them.
The yellow highlighting appears due to 'conditional formatting' that Google Sheets supports. This isn't necessary, but it makes any missing data really obvious.
I added a pivot table on a second sheet that summarizes all expenses and income for each project. So you have your Profit/Loss any time.
At tax time some filtering will be called for, but it will be pretty simple to do. Payroll is a challenge that I want to resolve for MyCorbu, but I don't have the need currently. I still think a payroll service is the way to go.
Here's the download link again if you want a copy of this. The zip file contains CSV, XLSX, ODS, and PDF versions.