 |
|
|
|
|
| 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: |
|
|
| Options for Payment transactions: |
|
|
| Options for Payables (PO Receipts transactions) |
|
|
| 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.
|
|
 |
| See ProServe II
Support page to download the latest ProServe
II Series versions. |
|
|
06/06/2007 |
 |
|