![]() |
Want Everyone in your Company to Run it Like a Business? run REAL/Easy 1-800-REALEASy (1-800-732-5327) |
|
Welcome to REAL/Easy’s
Interface to Accounting system. As a pioneer for interfacing brokerage
management systems, REAL/Easy is dedicated to making your business tracking
and accounting efforts as efficient and valuable as possible.
The following sections will illustrate how you can setup BOS to integrate with Peachtree. Interface Accounting Module’s capabilities.
Above is the
Interface Accounting “desktop” showing the two areas of “Export Posting
Data” and “Setup Posting Formats”.
To enable interface to your accounting system using the export posting commands, three types of postings are offered:
Each time a posting command is used to create an export posting file, the “accounting transactions” are “marked as posted” in REAL/Easy’s subsidiary ledgers. This means that the accounting activity in REAL/Easy will only appear in a single export file eliminating any “double posting” possibility. Unique batch numbers are created for each posting. Example commission checks export post and import into Peachtree.
In this example, a number of checks were printed in REAL/Easy and the accounting staff wish to record the details in Peachtree without double entry. The checks were for two days – July 19th and 20th. The “New Commission Checks Batch I23” command is used.
Above, the paid
date range is entered and the “Search” button clicked. The interface
displays all unposted checks for the date range. In this example there are 6
checks indicated by the counter at the bottom of the window. Example commission checks export post and import into Peachtree (cont’d)
The above dialog illustrates saving the export file. (The file name, e.g. “PAYMENTS.csv”, is assigned during “setup”).
Above, when the
file export is completed, this message will display. Click “OK” and you can
exit REAL/Easy.
Login to the brokerage company in Peachtree and select the “File” Example commission checks export post and import into Peachtree (cont’d)
In this example, the checks are imported into Peachtree’s Accounts Payable module. Under Accounts Payable, an import definition is setup and named “IMPORTS CHECKS FROM BOS”. Locate this, click to highlite, then click the “Import” tool at the top of the window.
This will start
the Import process. Click on the “Options” tab and click off “First Row…”
and on “Warn if Duplicate Reference” (this will verify that duplicate check
numbers are not imported). Then click the “OK” button. Example commission checks export post and import into Peachtree (cont’d) Viewing the
imported payments in Peachtree.
Above, sample payment to an agent that was imported into Peachtree. Note, the “Split” button can be used to view the account distributions:
Above, sample split showing all “distributions”.
Setting Up the Interface to Accounting.
The “Select Import/Export” command is used in Peachtree to both create the import item list and run the import itself.
To import checks printed in REAL/Easy, an import is setup under “Accounts Payable”. The type of import should be “Payments Journal”.
Use the “Fields” tab to select the import items in the “Show” column. Above illustrates selecting the first 3 of the 11 items to reside in the import file.
Above, selecting items 4 through 6 for the payments journal import definition.
Above, items 7 through 10 (G/L Account)
Above, the
amount item is the last field needed.
Above, final step for the import setup – saving the definition. Provide a name the helps you easily locate later when you run the imports.
Step 2 – Setup the BOS system to work with your
accounting system.
Enabling the
Interface.
Click forward
the “Interface Accounting” tab to enable and select the interface type
“Peachtree”. Also click the check box to “Enable Accounting Interface”.
There a number
of “default” account number setups you can do for the various sales revenue
and expense, balance sheet, agent billing, and agent deductions. These
setups will “lay-in” the desired account numbers when you are adding sales
transaction income and commissions details. Doing these setups will help
your data entry staff because they will not have to spend time changing the
account assignments when adding detailed sales revenue and commission
splits.
As shown above,
REAL/Easy ships with a chart of accounts that have 4 digit main numbers. To
add the balance sheet and income statement accounts you need to provide
Peachtree, use the “Add Update Chart of Accounts” command in REAL/Easy’s
“Basic Setup”.
Special setup for Multi-Office Companies: If you are utilizing department numbers for part of your account number or “CLASS” for the different offices in your real estate company, you can define these in the “Add/Edit Office” command. Above, Use each
office’s “Financial Department ID” for this. For multi-office companies who
use this department ID as part of their account structure, this item will be
included in the posting export file definition later.
The accounting interface export formats setups and batch export processing are all done within the Interface Accounting module. The module has these command options:
The IA setup is done within the above tabbed areas. In “General” you define the default paths and names of the export files. These are used for the export processing as the default names – they can be changed if needed. This example setup will be for the export of checks printed in REAL/Easy using the “Cash/Check Management Interface” tab.
For each posting/export type there are Header, Detail, and Footer rows. For a check export, the header is used to post the expense debit and cash credit. The Detail section is used to post deduction credit distributions. The footer can be used to indicate an end of transaction or for other total or count information as required by the accounting package.
Above, Each “Row” is added and edited with a screen similar to above. Table name and item drop downs are used to select the amount, account, reference, and other data you wish to export. Delimiters and other special key words and default values can just be directly typed into the bottom half window. The example shows placing the 10th item the account number.
Creating Posting Export Files
The “Export” commands are used to select the data and create the export files.
Above, the “New Commission Checks Export IA22”, run window. You can select any date range, a particular office (or all) and even individual transactions for your post. Only non- posted checks will be displayed. You can then select the checks to be posted one at a time or all at once.
Above – checks selected (highlighted) and Export button processing.
The export file can be viewed. Below shows a sample:
Above – example
processing and export file. When the export is completed, the check are
marked as posted in REAL/Easy and can be retrieved with the Re-Export Batch
commands.
|
|
Want Everyone in your Company to Run it Like a Business? run REAL/Easy 1-800-REALEASy (1-800-732-5327) |
![]() |