• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / Archives for PDF

PDF

What Is the QuickBooks Attached Documents Service?

Chief Mechanic · September 18, 2010 ·

QuickBooks Attached Documents is a new extra-cost service introduced with QuickBooks 2011 and Enterprise Solutions 11.0 that allows users to attach documents to QuickBooks lists or transactions from within QuickBooks. It replaces the Document Management service introduced with QuickBooks 2010.

Versions of QuickBooks prior to QuickBooks 2010 don’t support attaching documents to list items or transactions from within the QuickBooks program itself.

The storage-based limits used by the older Document Management service have been replaced by limits on the number of items that can be attached to a list item or transaction. Users of the older Document Management service can continue to use that platform at pricing levels previously agreed to, even if they upgrade to QuickBooks 2011.

Pricing for the QuickBooks Attached Documents service is:

  • $9.95/month for 1 attachment per list item or transaction
  • $14.95/month for up to 5 attachments per list item or transaction
  • $19.95/month for unlimited attachments per list item or transaction

The principal advantage that Attached Documents provides is the direct integration from within the QuickBooks program. For example, a PDF copy of a vendor bill can be attached to the transaction that records the bill in QuickBooks. Documents are stored on Intuit’s secure servers and are accessible over the internet. For organizations conducting business in multiple locations or that need to exchange documents with an accountant, such as during an annual audit, the direct association of an attached file with an accounting transaction can provide significant productivity improvements because the association is made once and saved. Other storage systems, even cloud-based systems, require a user to independently maintain the linkage between a file name in a folder and an accounting transaction, something that becomes progressively harder with changes in personnel and increases in the number of filed documents.

Vote This Post DownVote This Post Up (+2 rating, 2 votes)
Loading...

How Does a Client Import an Accountant’s Work From an Accountant’s Copy Import File?

Chief Mechanic · September 12, 2010 ·

To import an accountant’s work prepared in an Accountant’s Copy import file (.QBY), the first step is to receive and save the .QBY file on your computer.  Given the small size of most .QBY files, this file is normally transmitted via email.

For background, use of an Accountant’s Copy in QuickBooks is an easy way for a client company to transfer data to a third-party (such as an accountant), have the accountant make changes and return just those changes, and incorporate them with the company file subject to the client’s review.  In an article on our blog, we’ve described how a company can easily transfer an Accountant’s Copy export file (.QBX) to us using Intuit’s secure servers.  This file could also be delivered via other methods, such as delivery on a flash drive or other physical media.  In separate articles, we’ve reviewed how an accountant works with client data received from an Accountant’s Copy and returns that data to a client.

Working with an Accountant’s Copy is essentially a 5 step process:

  1. client sends an Accountant’s Copy export file (.QBX) to an accountant or third party
  2. accountant or third party works with the data
  3. an accountant or third party returns completed work to the client
  4. client imports changes made by accountant or third party
  5. resolving problems if the client import fails

Throughout this article, we’ll refer to different file types with similar names.  The function of each of these files is very specific. For more information, see our article describing the different file types in QuickBooks.

Here’s a sample message with an Accountant’s Copy import file (.QBY) attached.  In Outlook, right click on the attachment, and choose Save As… in the drop down menu.  Specify a location, and save the file.  Write down the location you specify so you can quickly locate the file when you return to QuickBooks.  The exact steps to save an email attachment may vary slightly in your own email client.

QuickBooks Accountants Copy Client Email

Once you’ve saved the file, return to QuickBooks.  Click the File->Accountant’s Copy->Import Accountant’s Changes… menu selection.  This menu selection will only be available if you have an outstanding Accountant’s Copy.

QuickBooks Accountants Copy Import

You’ll see the Incorporate Accountant’s Changes window.  Note that these changes are not yet incorporated – you’ll have a chance to review them first.

QuickBooks Accountants Copy Incorporate Changes

In this window, you can:

  • read the note from your accountant regarding changes made
  • review a list of those changes
  • print or save a PDF report of those changes
  • incorporate those changes into your company file

In this example, we recorded a single change in the .QBA file created from the client’s data, a journal entry.  Changes initially appear as single line items, and you can expand (+) or collapse (-) the detail that appears below a transaction by clicking the appropriate indicator to the left of the transaction.  If your accountant has recorded more than a few transactions, you can also click the Expand All and Collapse All buttons to perform those tasks on all of the transactions in the .QBY file.  At this point, the changes are described as not yet incorporated into your company file.  We’ve attached a sample report in PDF format showing the output at this stage.

After completing your review, click the Incorporate Accountant’s Changes button.  You’ll see a message that QuickBooks needs to close all windows.  Click Ok.

QuickBooks Accountants Copy Incorporate Changes Close All

Before incorporating the changes, as a precaution QuickBooks forces you to perform a backup.  To proceed and backup your data, click Ok.

QuickBooks Accountants Copy Incorporate Changes Backup

QuickBooks will prompt you to specify a file location and name to save the backup file.  When the backup is successfully completed, click Ok.  QuickBooks will proceed to incorporate the changes recorded in the .QBY file.

QuickBooks Accountants Copy Incorporating

When the changes have been incorporated, you’ll see a window reflecting the successful result.

QuickBooks Accountants Copy All Done

It’s strongly recommended that you click Print or Save as PDF to document the changes made.  If you click the Close button before producing a report of the changes, you’ll be cautioned to produce a report first.  Click Cancel to return to the previous window to print or save a report.  If you ignore the caution and click Ok, you’ll lose any chance to produce a report of the changes that were just incorporated.

QuickBooks Accountants Copy Print Caution

To document your work, click either the Print or Save as PDF button.  At this point, the changes recorded in in the Accountant’s Copy have been sucessfully incorporated into your company file.  We’ve attached a sample of the PDF produced by QuickBooks after this step.

Vote This Post DownVote This Post Up (+1 rating, 3 votes)
Loading...

How Does an Accountant Working With Client Data From an Accountant’s Copy File Return Completed Work To a Client?

Chief Mechanic · September 12, 2010 ·

The approach you use to return completed work to a client depends on which way you opted to work with the Accountant’s Copy export file (.QBX) file at the outset.  Intuit does not provide electronic communications to transmit completed work to a client however you chose to work with the file initially.  The simplest electronic method to transmit completed work is via email, but that may not be feasible if you opted to work with the .QBX file by converting it to a company file (.QBW).

For background, the Accountant’s Copy export file (.QBX) in QuickBooks is an easy way for a company to transfer data to a third-party, such as an accountant.  In an article on our blog, we’ve described how a company can easily transfer an Accountant’s Copy export file (.QBX) to us using Intuit’s secure servers.  This file could also be delivered via other methods, such as delivery on a flash drive or other physical media.  Intuit uses the terms “export” and “transfer” to describe a .QBX file interchangeably.  For simplicity, we’ll refer to this file as an export file because “eXport” serves as a better reminder of the purpose of the file extension, .QBX.

Working with an Accountant’s Copy is essentially a 5 step process:

  1. client sends an Accountant’s Copy export file (.QBX) to an accountant or third party
  2. accountant or third party works with the data
  3. an accountant or third party returns completed work to the client
  4. client imports changes made by accountant or third party
  5. resolving problems if the client import fails

Throughout this article, we’ll refer to different file types with similar names.  The function of each of these files is very specific.  For more information, see our article describing the different file types in QuickBooks.  In this article we’ll address how to return completed work to a client.

There are 2 ways to work with an Accountant’s Copy export file (.QBX):

  1. Convert it to an Accountant’s Copy working file (.QBA), which allows your changes to be automatically incorporated into the client’s company file, or
  2. Convert it to a company file (.QBW), which will not allow your changes to incorporated into the client’s company file

How work is returned to a client depends on the method you opted to use the .QBX file from the start.  Hopefully, before doing any work you evaluated which method best suited your needs, because once the work is completed, your options on how to return that work are limited.

Method 1 – You Previously Chose To Convert a .QBX to a .QBA File

The principal benefits of using this method are threefold:

  • your client can continue to record transactions in the company file after the dividing date,
  • QuickBooks will record only your changes in an Accountant’s Copy import file, resulting in a much smaller file to be transmitted to the client, and
  • tools are in place from within QuickBooks to easily document changes you made to the file.

This method is only available if you are working with the Accountant Edition of QuickBooks.  From within QuickBooks, click the File->Accountant’s Copy->View/Export Changes for Client… menu selection.

QuickBooks Accountants Copy View Export

With the View/Export Changes for Client window open, you’ll be able to:

  • record a note to your client describing the work you performed
  • review the changes you made to the file
  • print or save a PDF report of your work
  • create a .QBY import file (referred to as a Change File on the button) for transmission to your client

Here’s the View/Export Changes for Client window with important sections highlighted:

QuickBooks Accountants Copy Accountant's Changes

In this example, we recorded a single change in the .QBA file created from the client’s data, a journal entry.  Changes initially appear as single line items, and you can expand (+) or collapse (-) the detail that appears below a transaction by clicking the appropriate indicator to the left of the transaction.  If you’ve recorded more than a few transactions, you can also also click the Expand All and Collapse All buttons to perform those tasks on all of the transactions you recorded.

To document your work, click either the Print or Save as PDF button.  We’ve attached a sample of the PDF produced by QuickBooks.

Once you’ve documented your work, click the Create Change File for Client button.  This will create an Accountant’s Copy import file (.QBY) from the .QBA file.  The .QBY import file will contain only the data required to update your client’s company file, so it’s much smaller in size than other file types.  That makes it easy to transmit via email, since many internet service providers impose restrictions on the size of email attachments.  In addition, security is less of a concern because you’re not transmitting all of a company’s financial information – just a record of your changes.

When you click the Create Change File for Client button, you’ll be prompted to specify a location for the .QBY file.  Be sure to write down this location.  Open your email client, address an email to your client, attach the .QBY file you just created, and send it.  Your completed work is now on its way to your client.

Method 2 – You Previously Chose To Convert a .QBX to a .QBW File

If you opted to convert an Accountant’s Copy export file (.QBX) file to a company file (.QBW) and record your work in that company file, you’ll need to replace your client’s company file (.QBW) with the company file that contains your work.

Unlike the previous method, QuickBooks doesn’t provide any tools to assist in this process.

Because a company file (.QBW) is the primary file for recording data in QuickBooks for Windows, the file is considerably larger than other file types.  You may find that the size of the company file makes electronic transmission, especially via email, more difficult.  For example, the company file containing the sample data we used in these examples is 7944 Kb, or nearly 8 megabytes, in size.  By comparison, the Accountant’s Copy export file (.QBX) created from this company file to be sent to an accountant is only 328 Kb.  The Accountant’s Copy import file (.QBY) containing our 1 journal entry is less than 2 Kb in size, which is about the space required for 1 transaction.  If we had recorded 100 transactions resulting in a .QBY file of approximately 200 Kb, it would be easier to transmit that file via email than a file containing nearly 8 Mb of data.  If the company file (.QBW) containing your work is too large for transmission via email, you can consider:

  1. compressing the file with a file compression utility,
  2. using a file service that isn’t subject to the limits imposed by your internet service provider on email, or
  3. physical delivery of the file on electronic media.

Before replacing your client’s company file with the one containing your work, be sure to create a backup copy of the client’s data.  If the client did record transactions in the company file, those transactions will be lost once you replace the client’s company file with the one containing your work.  The backup will provide the ability to identify those transactions at a later date and enter them manually.

If you created and emailed a .QBY file, your client will need to incorporate the changes that are recorded in the Accountant’s Copy import file (.QBY) that you supply.  We describe incorporating the changes in an Accountant’s Copy import file (.QBY) in a separate article.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

How Do I Clear the Invoice Print Queue Without Actually Printing the Invoices?

Chief Mechanic · September 11, 2010 ·

There are 4 basic ways to clear the QuickBooks invoice print queue:

  1. uncheck the To be printed checkbox on each individual invoice
  2. send the invoices to an existing printer but delete the print job before it even starts
  3. install a new printer configured to print to a file rather than the printer itself and optionally delete the file
  4. use programming techniques to reset the To be printed flag

If you only need to clear a small number of invoices, the first approach is simple and straightforward.  Just find the invoice you want to remove from the print queue, uncheck the To be printed checkbox, and move on to the next invoice to be cleared.

QuickBooks Premier 2009 To Be Printed Checkbox

Unfortunately, it doesn’t take a very large number to make this approach impractical.

Our second approach solves the problem of clearing a large number of invoices.  Send the invoices to an existing printer with a specific configuration and delete the print job before it starts printing.  Choose a printer configured for print spooling and to start printing after the last page is spooled.  Turn the printer off before printing the batch of invoices in QuickBooks.  That means that you can tell QuickBooks to print the batch of invoices to that printer, but nothing will actually print.  The entire job will be sent to the printer, or spooled.  To verify your printer is properly configured, in Windows (not QuickBooks!) open your Printers window and right click on your printer and choose Properties from the context menu.  Then, select the Advanced tab.

Hewlett Packard Printer Properties Spooling

Be sure to select Spool print documents so program finishes printing faster and Start printing after last page is spooled, as shown in the above image.  (This image is from Windows Vista Ultimate SP1; the exact menus and descriptions may vary slightly in your version of Windows.)  This will insure that the entire print job is sent to the printer before it attempts to print the first invoice.  Since the printer is off, no printing will occur.  Now you’re ready to send the print batch from QuickBooks.  Once QuickBooks has finished sending the print batch to the printer, in Windows (not QuickBooks!) return to your Printers window, right click on your printer, and select Open from the context menu.  You should now see the print job or jobs that you need to delete.  If you need to delete a large number of jobs, click on the first job, then scroll down to the last job, and click on it while holding down the shift key.  All the jobs between the first and last will be selected.  Then, right click on a selected job and choose Cancel from the context menu.  The print job or jobs will be deleted without actually printing any invoices, and QuickBooks will clear the To be printed flag for all invoices on its own.

A variation on our second method is to send the print job to a file, such as an Adobe PDF, and then delete the file.

Our third approach is to install a new printer configured to print to a file rather than the printer itself before attempting to print invoices in QuickBooks.  During invoice printing, select the newly installed printer as the printer for this print batch.  The specific steps to install a new printer configured to print to a file are discussed in this Intuit knowledge base article.

Lastly, our fourth approach is to reset the To be printed flag using advanced techniques.  These file access techniques are beyond the capability of a typical QuickBooks user, and they’re most applicable when a large number of invoices need to be cleared and they need to be cleared selectively.  Using programming techniques, we can select large numbers of invoices far more efficiently than would be possible if performed manually.  If that’s your circumstance, send us an email and we’ll provide a quotation on the cost to clear the print queue.

This article discusses ways to clear the To be printed flag under normal circumstances, but there are situations where this flag won’t clear using these techniques.  One such situation is caused by a damaged invoice template.  In these circumstances, you’ll have to first restore normal operation by following the troubleshooting steps appropriate to that special situation before attempting to change the To be printed flag on a larger batch of invoices.

Vote This Post DownVote This Post Up (+1 rating, 3 votes)
Loading...

Can I Use My Own Email Client To Send Reports And Forms Via Email?

Chief Mechanic · September 10, 2010 ·

Beginning with the 2008 series of products, you can use your own email client to send reports and forms via email – provided that you have a preference set correctly, and provided that your email client is one of:

  • Microsoft Outlook
  • Microsoft Outlook Express
  • Microsoft Windows Mail

To use any of the above email clients, choose the Outlook setting on the Send Forms sub-menu on the My Preferences tab on the Edit->Preferences menu selection.

Whether you send a report or form via your email client or QuickBooks E-mail, QuickBooks will send the report or form as a PDF attachment.

Users of 2007 series and older are limited to using QuickBooks E-mail, which is an online service provided by Intuit.  Access to this service will no longer be available to QuickBooks 2007 users after May 31, 2010.

Online services are only available to users of a current QuickBooks version, so it’s important to monitor Intuit’s service discontinuation policy regarding the availability of online services for your version to avoid unexpected disruption to certain program features. 

If you need to upgrade your QuickBooks software to continue to be able to send important forms and reports via email, see the links on our Buy QuickBooks page.

QuickBooks Premier 2009 Preferences Send Forms Email

The principal advantage of using your own email client is that you can automatically preserve a copy of the emails you send in a folder in your email program.  With QuickBooks E-mail, you need to be sure to send a copy to yourself.

Vote This Post DownVote This Post Up (-1 rating, 1 votes)
Loading...
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 5
  • Go to Next Page »

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2023 QBGarage.com · Privacy · Terms & Conditions · Site Help