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.
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.
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.
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.
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.
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?
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.
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?
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.
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.
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.
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?
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.
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!!
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.
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?
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.
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?
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.
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.
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.
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.
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?"
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.