QuickBooks

QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.

Share tech news, updates, or what's on your mind.

Sign up to Post

Quickbooks
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
0
What does it mean to be "Always On"?
LVL 4
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:

      1. you are working in another QuickBooks file
      2. QuickBooks is closed

QuickBooks users who would benefit from this article are:

      1. Accountants or bookkeepers with multiple company files
      2. Companies with archived QuickBooks files for one company
      3. The Link Principle users who need to open receipts without opening QuickBooks


Using Microsoft Access


One way to import QuickBooks transactions into Microsoft Accesss is with spreadsheets. This is time consuming since you must first locate and open a memorized report and then save the spreadsheet exactly where you saved it last time.

A faster method exists for transferring data to Microsoft Access that does not require spreadhseets or QuickBooks reports. This article explains how to use VBA (Visual Basic for Applications) to exchange information with QuickBooks with an ODBC utility called QODBC. Copy and paste code is provided so you do not even have to know VBA to apply this method.

If you already know VBA, you can alter the code to suit your needs.

QODBC lets Microsoft Access read, insert and edit QuickBooks data directly without the need to learn the complicated QuickBooks SDK. Therefore, those with limited VBA knowledge can still create and customize their own QuickBooks add-ons.

Even if you do not use QODBC or have no intention of using QODBC,…
3
 
LVL 38

Expert Comment

by:younghv
Comment Utility
Another very nicely done article.
"Yes" vote above.
0
By Linda Saltz

Customized item descriptions from bills DO import into a customer invoice!  

This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the item list manageable, and still have the detailed description of what was purchased on a bill/check or credit  card to flow through to the customer invoice.

Examples:
When an IT firm buys a Hard Drive for a customer they enter the cost on a Bill or Credit Card Charge using a generic item named “Hard Drive” and enter the model, size and warranty information using the description field.  This customized description will also flow through to a customer invoice!
When a consulting company enters the cost for airfare, they will use a generic item named “Airfare” and include the travel dates and airline name using the description field.  This customized description will also flow through
to a customer invoice!

The challenge has been how to get that level of detail from these purchase transactions to an invoice.  YOU CAN import your item detailed descriptions from vendor bills, credit card charges and checks  into your customer invoices by following a few simple steps:

The Time and Costs Window of the invoice contains an option button that includes an option to “transfer item descriptions”.  But this is NOT ENOUGH to have the customized detailed descriptions of the purchase appear on the invoice:
QuickBooks Invoicing Tips for Contractors
QuickBooks Invoicing Tips for IT Firms
THE TRICK IS...
2
 
LVL 6

Expert Comment

by:Jenn Prentice
Comment Utility
This is a great Article! I worked with Quickbooks at my previous job, and I would have greatly appreciated an article like this!
Thank you for writing it! I hope to see more from you in the future!
-Jenn
0

QuickBooks

QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.

Top Experts In
QuickBooks