Anyone fluent with Quickbooks? at DVinfo.net

Go Back   DV Info Net > And Now, For Something Completely Different... > Taking Care of Business

Taking Care of Business
The pen and paper aspects of DV -- put it in writing!


Reply
 
Thread Tools Search this Thread
Old January 25th, 2013, 11:13 PM   #1
Major Player
 
Join Date: Nov 2009
Location: Norwood, MA
Posts: 252
Anyone fluent with Quickbooks?

My accountant suggested Quickbooks and I am learning my way around. My big question is:

If I take a deposit in 2013 and wedding is in 2014, when I do end of the year reports how does it show the deposit as income in 2013 and balance in 2014?

Thanks all.
Darryn Carroll is offline   Reply With Quote
Old January 27th, 2013, 01:57 PM   #2
Trustee
 
Join Date: Jul 2007
Location: Novato, CA
Posts: 1,772
Re: Anyone fluent with Quickbooks?

First, are you on a cash basis or accrual basis? That is something you need to determine first.

You should have started a new job and created either an invoice for the full amount or better a progress invoice. Then, when you received the deposit (which by the way you should change your standard payment procedure so that they are paying you a retainer, not a deposit), you will apply that against the invoice(s). Then have your reports set to "cash basis" and they will only show the receipts and payments you made to that date.
__________________
Garrett Low
www.GLowMediaProductions.com
Garrett Low is offline   Reply With Quote
Old January 28th, 2013, 05:38 AM   #3
Inner Circle
 
Join Date: Mar 2005
Location: Hamilton, Ontario, Canada
Posts: 5,742
Re: Anyone fluent with Quickbooks?

Quote:
Originally Posted by Darryn Carroll View Post
...If I take a deposit in 2013 and wedding is in 2014, when I do end of the year reports how does it show the deposit as income in 2013 and balance in 2014?...
According to my accountant, the income from work performed is taxed in the year the work is done, not the year in which payment is received. So a wedding shot and invoiced in 2012 with payment received in 2013 is taxed for 2012, not 2013. Your situation though is the opposite. In your case the deposit is not income but moneys held in escrow, in a manner of speaking, as prepayment against work to be done in the future. It doesn't become your money until you shoot the wedding and apply the deposit against the bill.
__________________
Good news, Cousins! This week's chocolate ration is 15 grams!
Steve House is offline   Reply With Quote
Old January 28th, 2013, 07:15 AM   #4
Major Player
 
Join Date: Dec 2005
Posts: 848
Re: Anyone fluent with Quickbooks?

Your accountant should set your QB system up for you and then show you how to enter everything, as well as explain the rules to you. If it's not set up correctly or the entries are screwed up then it ends up being a mess the accountant has to go clean up, costing you additional money. One useful thing my accountant did was add an account "Ask My Accountant" into which I enter transactions which I'm not sure how should be allocated. When I send the file for reconciliation he makes the appropriate allocation or sets up any new accounts needed.
Jim Michael is offline   Reply With Quote
Old January 29th, 2013, 12:26 AM   #5
Trustee
 
Join Date: Jul 2007
Location: Novato, CA
Posts: 1,772
Re: Anyone fluent with Quickbooks?

Quote:
Originally Posted by Steve House View Post
According to my accountant, the income from work performed is taxed in the year the work is done, not the year in which payment is received. So a wedding shot and invoiced in 2012 with payment received in 2013 is taxed for 2012, not 2013. Your situation though is the opposite. In your case the deposit is not income but moneys held in escrow, in a manner of speaking, as prepayment against work to be done in the future. It doesn't become your money until you shoot the wedding and apply the deposit against the bill.
Not sure how the tax codes work in Canada but in the US you have a choice of how you account for income and expenses, either on a cash basis or an accrual basis. You can only change your basis once but you do get to change it. In simple terms, on a cash basis you account for income and expenses on the date they physically occur. If you book a job on December 10 for for a job on December 25, do the job on the 25, but don't get paid until January 1, on a cash basis you would not show any income until January 1. On an accrual basis, you would show income on December 10. Also, if you received a bill on December 10 due January 1 for a camera you purchased, and paid the bill on Dec 25, on a cash basis you would show an expense for December 25, but on an accrual basis you would still not show an expense until January 1. Most companies with an inventory generally will benefit from an accrual basis and I believe are required to be on an accrual basis. Some companies without inventory will benefit from being on an accrual basis but more may benefit from a cash basis.

As Jim said, your accountant should set up your QB company so that is is very clear. No matter what basis you are on, if set up correctly, you should input invoices as you book the jobs including payment terms, and if coded correctly you will be able to toggle between cash basis and accrual basis. The same goes for bills you receive.

Darryn, I believe you are getting a little mixed up. Are you interested the report for tax accounting purposes or for business planning and finance purposes? For tax purposes, if you are on a cash basis, whatever the balance is does not matter, Think of it as cash in hand. If you are on an accrual basis, the only thing that matters is the payment terms agreed to. Think of it as only what the agreement says. If you have money owed to you that was not paid or is delinquent, you can account for that as bad debt that will be retired as you receive payment. I believe there are some additional requirements for bad debt but I am on a cash basis so I am not as familiar with those.
__________________
Garrett Low
www.GLowMediaProductions.com
Garrett Low is offline   Reply
Reply

DV Info Net refers all where-to-buy and where-to-rent questions exclusively to these trusted full line dealers and rental houses...

Professional Video
(800) 833-4801
Portland, OR

B&H Photo Video
(866) 521-7381
New York, NY

Z.G.C.
(973) 335-4460
Mountain Lakes, NJ

Abel Cine Tech
(888) 700-4416
N.Y. NY & L.A. CA

Precision Camera
(800) 677-1023
Austin, TX

DV Info Net also encourages you to support local businesses and buy from an authorized dealer in your neighborhood.
  You are here: DV Info Net > And Now, For Something Completely Different... > Taking Care of Business

Thread Tools Search this Thread
Search this Thread:

Advanced Search

 



Google
 

All times are GMT -6. The time now is 04:44 PM.


DV Info Net -- Real Names, Real People, Real Info!
1998-2017 The Digital Video Information Network