Huge Savings
Get our price list!
Buy with Confidence
from a Premier Intuit Reseller
Free Shipping
Direct from Intuit
No Sales Tax
(in some states)
Try it free for 30 days

Huge Savings!

Add-ons


CRM: Online marketing: Field service mgmt.: POS email marketing: Inventory: E-commerce: Reporting: Time tracking: Billing/invoicing: Travel/expense mgmt: Donor management:

Business Tools


Social media mgmt: Cloud applications: Email marketing: Webstores: Online chat:

Monthly Archives: March 2010

How to Limit User Access to One Bank Account in QuickBooks

I'm trying to setup a user in QuickBooks Pro that gives access to just one bank account, and not the others.  Can you help?
Unfortunately, you can only limit access to particular checking accounts in QuickBooks Enterprise.  In QuickBooks Pro and Premier, your only option is give no access to sensitive accounting activities which is an all or nothing selection.  You also need to give no access to sensitive financial reporting; otherwise, your user will be able to pull balance sheet reports which list your account balances.

QuickBooks Enterprise gives you a lot more control over what a user can and can’t do, including limiting access to certain checking accounts.  We always offer Quickbooks Enterprise for 20% discount.  Intuit offers additional discounts from time-to-time that we always pass on to our clients.  They're currently offering an additional 5% off (for as total of 25%).  Even more exciting for larger companies, they're currently offering 20-30 users for the price of 15.  

Visit our QuickBooks Enterprise page for a listing of our current promotions and discounts.


Visit our webstore for huge savings on QuickBooks!

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Web Store | Price List | Free Trials | Newsletter

How to Book Sales Tax in QuickBooks

Okay! I don’t have any hair left because I am trying to figure out all the ins and outs of how sales tax is recorded in QuickBooks. When I get the till slips I enter the sales tax into the Sales tax Liability account. Now, when I go to vendor and pay sales tax this reduces my bank account balance by that amount. It also reduces my sales tax liability account by the same amount. So far these are all balance sheet accounts. How is it registered on the P/L or Income statement? If it is not entered on the balance sheet, why? Or, is it that this was not our money to begin with? Am I on the right track? Not if the restaurant is paying past taxes, not sales is this a P/L account?
Sales tax does not impact your P/L because there’s no revenue or expense associated with it.  Your customers pay it and you pass it through to your state.  After you collect it, it sits on your balance sheet as a liability (because the money’s not yours) until you pay it. 

The only time it’d impact your P/L is if you didn’t collect enough for your customers.  In this case, the shortfall that needs to be paid by your business would be an expense.

One last thing to keep in mind, make sure to pay your sales tax liability through the Vendor > Sales Tax menu.  You need to pay it with a tax payment check. If you pay it with a regular check, your sales tax reports won’t be accurate.


Visit our webstore for huge savings on QuickBooks!

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Web Store | Price List | Free Trials | Newsletter

How to Transfer from a Reserve Fund to an Operating Fund in QuickBooks for Nonprofits

I am working with an institution using fund accounting in QuickBooks.

Funds:
Operating
Reserve

The institution maintains separate bank accounts for each fund and fixed assets are held in the operating fund.  When purchasing a fixed asset with Reserve account funds, the recorded transaction is:

Fixed Asset $9,000 (Debit)
Cash $9,000 (Credit) (Dedicated Reserve Fund Checking Account)

To transfer the asset to the operating fund and reduce the reserve fund balance, I also record the additional lines in the check or bill:

Reserve Fund $9,000 (Debit) (Equity Account)
Operating Fund $9,000 (Credit) (Equity Account)

Does you have suggestions for a cleaner way of recording the transaction? The second half of the entry is not very transparent.

These don’t sound like restricted funds, but you could use the same concept.  Create a revenue account called transfer from reserve fund, and an expense account called transfer to operating fund.  Then debit the expense account using the reserve class, and credit the revenue account using the operating class.  This will show the money coming out of reserves and into operating. 

You’ll still need to transfer the equity account as well, since both the debit and the credit will offset each other when net income closes to retained earnings at year-end.


Visit our webstore for huge savings on QuickBooks!

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Web Store | Price List | Free Trials | Newsletter

How to Prepare Job Costing Reports for Unbilled/Unpaid Costs in QuickBooks for Contractors

Now that I have an extra moment or two.  Just to close the loop … the report you and I were working from is based upon hours that have been invoiced.  However, I am looking for a report (as I mentioned earlier) that needs to be based upon hours "billed" to the project … can you see if QuickBooks can report on those hours/billing rates for me?  Or, is there someone you can recommend at QuickBooks that I can call to see if that type of report is available? Thanks for your efforts.  I presume you had a festive Saint Patty's Day!!
Unfortunately, you can’t get uninvoiced time and billing rates on the same report.  The two pieces of data don’t get matched up in QuickBooks until you create an invoice.  There is a reasonably-priced Job Cost Reporter add-on that creates job costing reports, includes unbilled cost, open purchase orders, unbilled time, unpaid time and quantities. 

Visit our webstore for huge savings on QuickBooks!

This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Web Store | Price List | Free Trials | Newsletter