| Transfer of
GL Transactions PROPERTY
MANAGER has a powerful integration to ACCPAC Plus or ACCPAC Advantage
General Ledger. The transfer of GL information is a function of Month End
Processing. GL transactions can be transferred in Detail or consolidated.
Both Cash or Accrual accounting methods are supported simultaneously.
Transfer
to ACCPAC Advantage
- Change Transfer Layout - source code - Header - Source Type "SRCETYPE"
should be Mapped field "Source Type".
- Include title record
- Select 4 digit year "Date Formatting" on transfer screen
- In ACCPAC Advantage create a new GL Journal Entry batch. Select File and
Import from the menu. In the "Type" field select "Single
CSV File". In the "File" field enter the same path as the
Transfer location on the transfer screen in Musick Manager. Because of the
title record in the CSV file, all of the import fields are defined. Just
click the "OK" button to import the GL entries.
Transfer
to ACCPAC Plus
- Only Format 1 is supported for importing
- Change Transfer Layout - Entry ID Number should be changed to "Increment
Entry No."
- Exclude the title record
- Select 2 digit year
"Date Formatting"
on transfer screen. If a 4 digit year is selected, the import batch in GL
will have an invalid fiscal period.
- In ACCPAC Plus GL select "Transaction Processing" -
"Batch Processing" and "Import batches". Specify the
same path to the import file (*.csv) as the Transfer location field on the
transfer screen in Musick Manager.
Optional
Fields
Select the optional field to include in the Transfer Layout. In the
Setup-Options for each application specify the information to place in the
Optional Field.
Consolidation
Methods
GL Transactions may be transferred in "Detail" or
"Consolidated". The Consolidation Method is changed in the
Setup - Options for each application. Select the "GL Transfer"
tab. The available methods are:
No Consolidation- each transaction is sent to the GL-
Consolidation:
-In Detail-Billing Entry Income Account in Detail/Receivable Account in
Summary
-Cash Entry Checks
In Detail/Bank Account in Summary
-Detail/Invoice# -
-Detail/Summary -
-Detail/Cash -
-By Batch - Accounts are grouped by batch number.
-Date/Source Code - Accounts grouped by Date and Source Code
-Date - Accounts are grouped by Date
-Period/Source Code - Accounts are grouped by Period and Source code..
-Period - Accounts grouped by Period
-Account - Entries grouped by Accounts - entry date is specified by the
user on the transfer screen.
GL
Source Codes
Source codes need to added manually into the General Ledger.
Here are the Source Code to add for PM:
PM-IN
= Invoice
PM-IT = Interest
PM-LT = Late
PM-AD = Adjustment
PM-CS = Cash
PM-AC = Adjustment to Cash
PM-NF = NSF Reversal (Non sufficient funds)
PM-SD = Security Deposit
PM-CO = Consolidated entry
Here
are the Source Code to add for AP:
AP-IN = Invoice
AP-AD = Adjustment
AP-PY = Payment
AP-NF = NSF (Non sufficient funds)
AP-VT = Void Transaction
AP-IR = Invoice Reversal
AP-PR = Payment Reversal
AP-DA = Discount Added
AP-UP = Unapplied Prepayment
AP-AP = Applied Prepayment
AP-AI = Prepayment applied to Invoice
AP-CO = Consolidated entry
Property Manager Accounting
|
|
Accrual
Accounting |
Cash
Accounting |
|
DR |
CR |
DR |
CR |
|
AR Billing |
A/R acct |
Inc acct |
A/R acct |
Cash Clear Ctrl |
|
|
|
|
|
|
|
AR Cash Rcpt |
Bank acct |
A/R acct |
Bank acct |
Inc. acct |
|
|
|
|
Cash Clear Ctrl |
A/R acct |
|
|
|
|
|
|
|
Adjustments |
|
|
|
|
|
AR Bill |
Inc acct |
A/R acct |
Cash Clear Ctrl |
A/R acct |
|
|
|
|
|
|
|
AR NSF |
A/R acct |
Bank acct |
Inc acct |
Bank acct |
|
|
|
|
A/R acct |
Cash Clear Ctrl |
|
|
|
|
|
|
|
AP Invoice |
Exp acct |
A/P acct |
Cash Clear Ctrl |
A/P acct |
|
|
|
|
|
|
|
AP Check |
A/P acct |
Bank acct |
Exp acct |
Bank acct |
|
|
|
|
A/P acct |
Cash Clear Ctrl |
|
|
|
|
|
|
|
Adjustments |
|
|
|
|
|
AP Invoice |
A/P acct |
Exp acct |
A/P acct |
Cash Clear Ctrl |
|
|
|
|
|
|
|
|
|
|
|
|
|
AP Check Rev. |
Bank acct |
A/P acct |
Bank acct |
Exp acct |
|
|
|
|
Cash Clear Ctrl |
A/P acct |
|