You have guest access to browse, login, or register.

Intuit QuickBooks Community
Username:
Password:
Remember me
Register for Free! Forgot your password?
     Advanced
Search
QuickBooks Community  / Forums  / Ask the Expert  /
Ask the Expert: Laura Dion - READ ONLY
Jan 11, 2008 02:45 pm
Wrapping up the books for '07? Get it right the first time! Laura Dion will be here to answer your toughest questions!
Laura is a Certified QuickBooks ProAdvisor, and provides QuickBooks consultation through her business, Cents-able Bookkeeping.

***This event is closed. You will not be able to ask questions but you can still read the posts.
  1   2   3   4   5   6   7   8   
9
Replies to Ask the Expert: Laura Dion
[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#199
of 223
Answer: Remove transactions AFTER a given date???
Jan 18, 2008 05:48 pm  
 
That would be a useful feature for others as well.

The only thought I have is to research

http://marketplace.intuit.com

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[Sandy888]
Sandy888

New Member

Ohio

Total posts: 1

#200
of 223
Question: 3 Part Invoices
Jan 18, 2008 05:48 pm  
 
HOW DO WE PRINT 3 INVOICES WITH 3 DIFFERENT HEADINGS TO SPECIFY THEM AS

OFFICE COPY /
CUSTOMER COPY /
DUPLICATE COPY /

WE ARE PRINTING ON PLAIN PAPER AND WOULD LIKE TO HAVE THIS OPTION.
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#201
of 223
Answer: 3 Part Invoices
Jan 18, 2008 05:51 pm  
 
First of all, you can order QuickBooks compatible invoice blanks from QuickBooks or most check printing supply houses.

The one thought I have is this:

Run your paper through the printer using Word to print those headers.

The other is to customize 3 templates and print one at a time. . .sounds tedious to me, but it would work. Once you create the invoice and print it, you could view/print it in the other two templates.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[triciakos]
triciakos

New Member

Missouri

Total posts: 1

#202
of 223
Question: PC and Mac
Jan 18, 2008 05:52 pm  
 
I have a question that might have been asked already, but don't see it. Are any of the QB products transferrable from Mac to PC and PC to Mac? If so, which ones? The reason I ask is I have Windows Pro 2007 and my potential client has Mac (? Version). Want to know if the files will be recognized on both.

Thanks,
Tricia
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#203
of 223
Answer: PC and Mac
Jan 18, 2008 05:54 pm  
 
I think you might be able to do it, but you would be jumping through hoops. .."save as Mac" convert to PC and back again.

I wouldn't risk it with a client file.

I would suggest that you see if you can do the work onsite.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[gwithers]
gwithers

New Member

Texas

Total posts: 1

#204
of 223
Question: Assembly item setup
Jan 18, 2008 05:55 pm  
 
In Quick Books Premier Manufacturing the cost to a build an assembly item depends only on the cost of its components. How do you add labor to the assembly process and how do you enter this assembly item into inventory after the work order is completed for the item?
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#205
of 223
Answer: Assembly item setup
Jan 18, 2008 05:58 pm  
 
You can create an item which links to the labor expense account.

When creating the item, check the box that indicates that this item is used in assemblies and assign and expense account.

Then, when you build your assembly item, you can select the labor item.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[RobertE]
RobertE

New Member

New York

Total posts: 1

#206
of 223
Question: Non- Profit Fund accounting
Jan 18, 2008 06:01 pm  
 
Concerning setting up for a church. We have 1 checking account. How do I set up to keep track of how much money is in the general fund, missions fund, and building fund. I set up all our budget items and can't figure out the separation. I am using Pro 2008. Is that enough info to provide a solution?
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#207
of 223
Answer: Non-Profit Fund accounting
Jan 18, 2008 06:05 pm  
 
Create a bank type account called 'Checking'. (do not enter any opening balance)

Move your current bank account, renamed to General Fund, as a sub account to this one.

Then, create another sub account called Building Fund. (do not enter any opening balance)

Then, create another sub account called Missions Fund. (do not enter any opening balance)

Transfer the total amounts of each fund to that sub account to get you started with good numbers.

When you reconcile, use the parent account.

When you make deposits to, or pay for things out of, the particular account, use that sub account.

For all others, use the General Fund account (now a sub).

Do not post anything to the parent account.

This should give you what you need,

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[cooper39350]
cooper39350

New Member

Mississippi

Total posts: 1

#208
of 223
Question: Budget reports
Jan 18, 2008 06:09 pm  
 
We have a set budget each fiscal year, which is different from the calendar year. When I print reports, is there a way that it can list the "entire" budget amount, rather than dividing it by 12 to display it as a "monthly" amount? That way it would keep the total budget amount and show the amount paid "to date" for the category.
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#209
of 223
Answer: Budget reports
Jan 18, 2008 06:12 pm  
 
You can customize your budget performance report to total by year/qtr/month.

Go to Reports>Budgets & Forecasts>Profit and Loss Budget Performance.

Open that and go to Modify and select the option to total by. . .

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[LisaBooks]
LisaBooks

New Member

California

Total posts: 10

#210
of 223
Question: Entering Inventory Items
Jan 18, 2008 06:21 pm  
 
Thank you for all this info, Laura! (Even if you don't get to my question.)

My problem: some of our bills were entered and paid without attaching the PO or item receipt. The items were re-entered on the bill when the bill was entered into QB (under Items instead of Expenses).

So now I have POs and Item Receipts hanging out there looking like they were never billed or paid for, and unattached paid bills for the same items. Does this mean the items were received twice in QB - so my inventory would be double for the items?

Is there a way to go back and attach the item receipts to the bills that have already been paid?

Lisa
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#211
of 223
Answer: Entering Inventory Items
Jan 18, 2008 06:24 pm  
 
If you used items for the bills, then you can delete the item receipts and you will be fine. (yes, your inventory is off by this amount)

Purchase orders are non-posting, so will not affect your financials.

However, I would delete them.

When you enter a bill for a vendor that has item receipts or open PO's, you will get a warning. .. you should heed this (and train others to do the same).

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[texas-68]
texas-68

New Member

Texas

Total posts: 3

#212
of 223
Question: Beginning Balance
Jan 18, 2008 06:25 pm  
 
I have converted all by quicken files to quickbooks. Ten years worth. I have updated my transactions and I am ready to reconcile my bank statement. It will not except an opening balance for the bank statement. Any suggestions? Thanks!!
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#213
of 223
Answer: Beginning Balance
Jan 18, 2008 06:28 pm  
 
When reconciling a bank statement, the beginning balance is the amount that was reconciled in QuickBooks.

Since you have yet to reconcile in QuickBooks, that shows a zero.

Don't worry about it. . .put in your ending balance and reconcile your latest statement.

(You might have to reconcile the whole ten years at once. If so, don't print the report!!)

Going forward, you will have last month's reconciled balance as your beginning balance.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[goekmeno]
goekmeno

New Member

Virginia

Total posts: 1

#214
of 223
Question: Vendor Credit
Jan 18, 2008 06:30 pm  
 
Hi,

I have entered a vendor credit of $15 in QB in the month of October. The credit is with American Express. There have been no charges to the same credit card and I requested a check to close the account. The check was entered in QB, but it did not zeo out the credit balance of $15 in QB. What should I do to zero out the transaction?

Please advise!
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#215
of 223
Answer: Vendor Credit
Jan 18, 2008 06:31 pm  
 
You say it is a vendor credit.

Therefore, you need to be sure that the deposit uses Accounts Payable with the vendor name.

Then, go to Pay Bills. Select the 'bill' and apply the credit.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[dietrich]
dietrich

New Member

Washington

Total posts: 3

#216
of 223
Question: Sales tax collected
Jan 18, 2008 06:32 pm  
 
When I look at my profit & loss statement the income is not reflected properly. The income doesn't show the tax that is collected on the invoice amount that the client is paying. We are a construction co. and the income is either us as a general contractor (collecting sales tax) or as a sub on others jobs (1099-not collecting sales tax) However, the income on profit & loss statment leaves off the tax amount that we have collected. Any advice on how to fix it?
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#217
of 223
Answer: Sales tax collected
Jan 18, 2008 06:33 pm  
 
Sales tax collected is not income.

You are merely holding the sales tax for the gov't until which time you pay it.

You will see the sales tax collected moving in and out of your Sales Tax Payable account.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[depanfilis]
depanfilis

New Member

Connecticut

Total posts: 2

#218
of 223
Question: Fiscal vs calendar year reports
Jan 18, 2008 06:38 pm  
 
We have a fiscal year end of 9/30/07. I was double checking on balances for subcontractors for 1099s in the general ledger.

I set the dates for the report for January - December 2007. When I view the report, I only see October - December 2007 in the subcontractors account.

Why can't I view the entire calendar year?
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#219
of 223
Answer: Fiscal vs calendar year reports
Jan 18, 2008 06:46 pm  
 
If you run your report, the first number is 'Retained Earnings', which represents the total for 01/01/07 to 9/30/07.

This, added to the current year data, is your total calendar year.

You can also run report a Vendor Quick Report and select the date range.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[dietrich]
dietrich

New Member

Washington

Total posts: 3

#220
of 223
Question: Sales tax adjustment
Jan 18, 2008 06:48 pm  
 
I have not been using the feature "say sales tax". So it looks like I have a huge liability to Dept of Revenue. However, I am paid up on the taxes owed but want to know how to make an adjustment so that this huge # will go away and accurately reflect a current status. Then I will, for 2008 do it the correct way. Can you help me with how to record this in QB so that it is accurate.
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#221
of 223
Answer: Sales tax adjustment
Jan 18, 2008 06:51 pm  
 
Try this:

Vendor>Sales tax>Adjust sales tax.

Enter an adjustment for the total that your account is 'out of whack'. Use whatever account you used when you made your sales tax payments.

Then, go to Vendors>Sales Tax>Pay Sales Tax and check your adjustment and 'pay' the same amount to the original posting.

This will give you a zero check and get you ready to move forward.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
[tlmarco]
tlmarco

New Member

Florida

Total posts: 1

#222
of 223
Question: COGS and Inventory
Jan 18, 2008 07:02 pm  
 
"I am used to working in a service industry. The new company I am with uses COGS for our product and all shipping expenses. Why are the COGS for every sale plus any check we paid to the vendor showing up on the P&L? It appears to inflate our actual COGS by including the payable and the sale? It may be just a long day, but I am confused. Is the item set up wrong or is this standard, requiring a JE?"

Tammy L.
Replies to this message

[ldion]
ldion

QuickBooks Community Expert

Certified ProAdvisor

Allstar

QuickBooks Certified User

Rhode Island

Total posts: 5097

#223
of 223
Answer: COGS and Inventory
Jan 18, 2008 07:12 pm  
 
It sounds like something is askew with the setup/processing of this file.

Since COGS is being 'hit' for each sale, an inventory item must be being used in the invoice/sales receipt.

If, in fact, you are selling inventory items, that would be fine.

However, you say that COGS is 'hit' when you pay for goods. If this is inventory you are buying, you aren't adding to the inventory when making purchases. However, you are removing inventory items when selling them.

I would guess that your inventory asset account has a credit balance by now. (It should be a debit balance).

If my assessment is correct, you need to decide. . .are you tracking inventory?

If so, enter purchases using items that are set up to use the Inventory Asset account.

If not, enter sales using non-inventory or service type items.

Either way, it sounds like you could use an experienced QuickBooks consultant to help you clean up and re-organize your file and procedures.

Laura D

Cents-able Bookkeeping______QuickBooks Setup, Consultation, and Training______ (I am neither a CPA, nor an Intuit employee.) My posts are intended to assist the QuickBooks user in processing data and are not to be interpreted as accounting advice.

______ For personalized consulting, feel free to e-mail me at the address on my profile.
    Previous   1   2   3   4   5   6   7   8   
9
XML RSS feed
QuickFeeds
Post to Del.icio.us
Digg!

In order to post a message, you must login.