[AccessD] Budget spreadsheet - was RE: consulting fees

jwcolby jwcolby at colbyconsulting.com
Fri Oct 5 07:20:38 CDT 2007


LOL, OK.  I am sure that the rest of us wish we could be paid once per year.



John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, October 05, 2007 1:41 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Budget spreadsheet - was RE: consulting fees

Embarrassing to admit but I still keep the corporate books on a thirteen
column green pad.  In pencil.  Been working effectively like that since
1980.   Think of it as the original spreadsheet.  

I use the cigar box method of accounting.  Put all the money in the box as
it comes in.  Take money out to pay the business expenses as they come in.
Whatever's left in the box at the end of the year is mine.  One paycheck in
December - the accountant calculates all the state and federal skim. Keeps
things simple.

BTW, I take the minimum paycheck I can get away with.  The balance, God
willing there is some, goes directly onto my personal return anyway since
it's a sub-S corp.  But it saves quite a bit on the SS - both mine and the
corp's - and Medicare taxes and some state taxes.

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, October 04, 2007 7:51 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Budget spreadsheet - was RE: consulting fees

I have developed a really cool and useful spreadsheet to allow me to track
my actual expenses, income, taxes etc.  It has so far been a work in
progress, leaving last month's sheet locked and copying it to a new sheet
for this month, then to new sheets for "out into the future".  It allows me
to input my actual billing (from the previous month) or projected billing
which will be the "income".  

I have columns for Expense name, Expense amount, "will pay this someday",
paid but not cleared and cleared checkboxes (actually little Xs).  

Putting an x in those columns copies the expense amount over to a "paid but
not cleared" and "Paid and cleared" column.  The Expense Amount, Billed Not
Paid and Billed and Paid columns get summed at the bottom.  Thus these three
columns show what my expenses are, what expenses have been paid but the
money has not been deducted from my account, and bills paid and deducted
from my account.   

I use internet banking and can see my bills clear and my account balance at
any given instant in time which I copy into the spreadsheet as I update the
Xs that mark bills paid not cleared and paid and cleared.

Off to the right side I have a pair of columns to track the bank account,
Billing not received, Paid not Cleared etc.

Also in the same column I have a small section for tax deductible items -
medical insurance, mortgage interest, SEP IRA, FICA (self insurance
actually) etc. 

Way off out of sight I have a section to compute the FICA using the rules
for Sole Proprietor.  Another area calculates the Progressive tax on the
actual (annualized) taxable amount.

And finally a section that computes my taxes (roughly) and feeds it back in
to the expense column.  

Doing all of this allows all of my totals to change as I enter any bill over
in the left hand "expense amount" column.  Also as I change my billing it
updates my taxes owed and subtracts all expenses (taxes are fed into the
expense column) to give me a "net after expenses" (truly sad).

But... The good news is that for the first time EVER I know my financial
state given my bills and a billing amount.  And it WORKS!  I can see what my
FICA is so I can save that in a tax account, and what my state and federal
taxes will be after legitimate deductions so I can save that in a tax
account.  In future months I can play with how much I pay to credit cards
(I'm paying them off), how much I pay into my various tax deductions such as
medical and SEP Ira and have that instantly feed back to tell me how much
has to go into the tax account (again, roughly) as my deductions change.  Or
how much I have to work (bill) to pay all the bills and have X dollars left
over.  It can be depressing but at least I know where I stand or where I
could stand if I worked 20 hours every day.

Would anyone care to comment on what you use to know your financial
position.

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Thursday, October 04, 2007 11:43 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] consulting fees

John,

  You make an excellent point.  There are some other things that do go up as
a result as well, like workmen's comp and disability insurance, but those
are minor when compared to the government's take<g>. 

Jim.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.1/1050 - Release Date: 10/4/2007
5:03 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list