QuickBooks Export Utility....

 

The QuickBooks Export Utility add-on program is now available for download..

***We encourage you to READ this page before downloading***

It contains important information that will help you determine if this utility is right for you.


     This utility is designed to export ProServe II Series data out into QuickBooks Pro 2006 compatible import file formats (IIF, Delimited Tab format). At which point can be imported into QuickBooks by using the import feature found in QuickBooks. This utility is not what I would call a QuickBooks Interface, but an Export Utility, hence the name. A Interface would imply that QuickBooks gets updated during the posting process of  ProServe II. That's not the case with this utility, it's more of a batch processing procedure performed at the end of a period or what ever time frame you choose to use.

 

QuickBooks Pro 2006
      This utility was designed and tested using QuickBooks Pro 2006. In order to export ProServe data into QuickBooks, the export file formats or file structures must match the QuickBooks import file formats of the version that you may be running. In reality this export utility program is creating QuickBooks Import files. The records in a QuickBooks import file are identified by a record code in the first field of each record. These codes are described in the QuickBooks help file, and may vary from version to version. However, in later versions these import file formats are the same and are the defaults for this Export Utility. This utility allows these formats to be customized to fit the QuickBooks version you may be running.
 
ProServe II Series Compatible Versions:
  • ProServe II v2.01a or later (US)

  • ProServe II v2.01a or later (UK)

  • ProServe II PLUS v1.2027b or later (US)

Data that can be exported is:

  • Accounts Receivable, Invoices, Credit Memos, Returns, Late Charges and Payments

  • Accounts Payable, PO Receipts.

Options for Invoice and Credit Memo transactions:
  • Detail or Summary

  • Department or Service Code (Income Accounts)**

  • Post Date or Close Date

  • Sorted by (Customers, QuickBooks Account Assignments)

Options for Payment transactions:
  • Detail or Summary

  • Post Date ONLY

  • Sorted by (Customers, QuickBooks Account Assignments)

Options for Payables (PO Receipts transactions)
  • Detail or Summary

  • Post Date ONLY

  • Sorted by Vendor (must be setup in QuickBooks)

Export Log History File

    Each export build is recorded in the Export Log History File to help keep track of time frames that has been run for export. It allows you to view any last export file to verify records and totals before importing into QuickBooks. It's up to you to import these files into QuickBooks. In a nutshell this utility creates export files based on the time frame you enter and overwrites the previous export files.  What this utility refers to as export files are import files to QuickBooks.

 
QuickBooks Income Accounts**

     You can choose to use your Department Codes or Service Codes as income accounts for importing into QuickBooks. This utility will create default income account assignments 1st time in and allows you to customize these accounts. These income accounts should be setup in QuickBooks to match ProServe II.

 
QuickBooks Customer Accounts

    QuickBooks Customer Account Assignment file should be setup to match QuickBooks. You will be able to assign ProServe II Customer Accounts to QuickBooks Accounts, otherwise each ProServe II customer account must be setup in QuickBooks. Although QuickBooks will create them as they are imported, we DO NOT recommend that you export by each individual ProServe II accounts. We recommend that you setup as few QuickBooks Customer Account Assignments as possible and assign ProServe II accounts to them. The reason is because this utility will not export invoices as paid, instead each invoice is exported as opened. (no matter what the AR status is at the time of the export) PAYMENTS must be applied within QuickBooks after each import. With that said let me give you an example:

  • we have a ProServe Customer "ONE" and customer "TWO" and "THREE"

  • we post work orders for each one.

  • only customer "TWO" had payments applied.

  • we export these transactions using the (individual account method)

  • we would have three new customers in QuickBooks.

  • we would have to select each individual customer to see if a payment was just imported.

  • after selecting account "TWO" we find a payment that must be applied to any open invoices.

  • after that you select the last customer "THREE" to find no payment, good we've finished for today.

     I hope you see where this is going, this example was only three accounts, it would be a nightmare to export hundreds of transactions per week using this (individual account method). BUT Let me remind you that ProServe II is a very good Accounts Receivable system by itself. If you plan to print invoices and statements with QuickBooks then you'll have to use this (individual account method) and will be creating more accounting work for yourself than what's necessary. This Export Utility will allow you to do that, but keep in mind all payments must be applied again in QuickBooks. At this point you may be asking why would I purchase this Export Utility program? What good would it do? Those are good questions and you should read the next section to determine if this utility is right for you.

 
Why Purchase this Utility?
  • By assigning ProServe II billing accounts to as few QuickBooks customer accounts makes it very easy to apply payments imported in SUMMARY.

  • By importing Invoices in detail, you can see each individual invoice under each customer.

  • You can see or report on each invoice posted into each income account.

  • QuickBooks can see all individual invoices for reporting purposes.

  • By double clicking an invoice, you can see detailed information about that invoice. Like bill to name and address, service to name and address, service code and amount, technician code etc..

  • You can export on a daily bases so payments can be posted to Undeposited Funds.

  • Credit Memo and Returns can be exported in Detail or Summary, but must be applied just like payments.

  • Sales Tax is posted to Sales Tax Payable.

  • Purchase Order receipts is posted into Accounts Payable. (by vendor)

  • The idea of this utility is to import ProServe II Accounts Receivable transactions into QuickBooks in a way that makes it easy to apply payments and have as much invoice information as possible for reporting and accounting P&L info etc…

Why this Utility may not meet your needs?
  • If you plan to print invoices and statements in QuickBooks. This utility can export by individual ProServe II customer accounts but all transactions are exported as opened. This requires you to re apply payments after importing into QuickBooks.

  • If you're looking for ProServe II to post into QuickBooks during the posting process. This utility is not designed to do that, it's a batch processing export utility not an interface.

  • If you're looking to post all transactions in SUMMARY, this utility will do that, but it may be just as easy to manually post General Journal entries.

Download QuickBooks Export Utility..  Click here for current Pricing..
  • This is an optional add-on product designed for latest ProServe II Series products.

  • It comes with a Single User License and that's all that's required to run on your network.

  • It has it's own activation key similar to the ProServe II activation key system.

  • For now this utility is not distributed on CD's but can be downloaded, installed and uninstalled very easily.

  • Please be sure to read this page from top to bottom before downloading.

  • Feel free to download if you're trying out any ProServe II Series product.

  • Download FREE 30 day trial.

Click here to download a free trial...

See ProServe II Support page to download the latest ProServe II Series versions.

09/05/2008

Top of Page

 

 

For more information, e-Mail Us or call toll free 1-877-903-6176   8:00am - 5:00pm Mon-Fir (cst)

 

Powered by EasyBee Software LLC Copyright © 2003