Architekwiki
  • WIKI
  • Start Here
  • Resources
    • Arch Fin Model
    • MyCorbu
    • Trello-PM
    • FeeCalqs
    • OFFPLAN
    • Reading List
    • Free Resources
    • All Resources
  • Other
    • Details
    • About
    • Sign Up
    • Terms of Use
  • MyCorbu APP
  • WIKI
  • Start Here
  • Resources
    • Arch Fin Model
    • MyCorbu
    • Trello-PM
    • FeeCalqs
    • OFFPLAN
    • Reading List
    • Free Resources
    • All Resources
  • Other
    • Details
    • About
    • Sign Up
    • Terms of Use
  • MyCorbu APP

Architekwiki

A Resource For Architects
Subscribe

No-Cost Bookkeeping

12/19/2016

0 Comments

 
Bookkeeping
For this past year I have been using Harvest for bookkeeping. As a reseller of Harvest the account has been free. Harvest isn't designed to do bookkeeping, but its 'personality' lends itself to being customized for that purpose. 

I need to do something different for 2017. You might find a solution here for your 2017!
​
Harvest won't be a sustainable solution for me. I will be changing to MyCorbu when its Expense module is ready. And the Harvest account won't be free anymore when I launch MyCorbu Timekeeping in early 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.
​
​In just a few hours I was able to set up this Google Sheet. Part way through I realized that this could be a learning experience. I added a few things that I won't need, but that an architect would. Of course, each row is a transaction. My columns are named: 
  • 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.
Bookkeeping
If you would like articles like this sent to your inbox, SUBSCRIBE.

Create your competitive edge. Trello-PM. A Project Management guide.

Use FeeCalqs, a digital Fee Calculation tool.

​
​###
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Resources

    Start Here

    Picture

    Picture

    MyCorbu

    Trello-PM

    FeeCalqs

    Picture

    Terms of Use
    Your use of Architekwiki is implicit agreement with the 
    ​
    Terms of Use.

    RSS Feed


    Categories

    All
    Business Development
    Communications
    Concepts
    Design
    Detail
    Estimating
    Finances
    Legal Issues
    Management
    Miscellaneous
    Money
    MyCorbu
    People
    Planning
    Process
    Projects
    Records
    Services
    Specifications
    Standards
    Time
    Tools


    Archives

    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    June 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012

    Resources
VISIT ARCHITEKWIKI'S RESOURCES
Picture
Architekwiki | Architect's Resource | Greater Cincinnati | (859) 444-4560
© 2012-2020   Architekwiki​