Page tree
Skip to end of metadata
Go to start of metadata
Historical Data Item
Considerations
How to
Post to GL Property
Post to GL Date
General Ledger Beginning Balances

Periodic Reporting Needs: monthly, quarterly, annual

Level of granularity: organizations, accounts, etc


Request Customer's Trial Balance, preferably as .csv or .xlsx

Enter Journal Entry in UI or General Ledger Journal Entry Import (see General Ledger Beginning Balances (Trial Balance))

YesBlank or previous to file date
Open Accounts Payable Items at initialization

Enter individual open AP invoices and unapplied payments

These items will be processed via AP in the future and should always be entered at the document level.  Partially paid items can be entered at their net amounts or as original invoice amounts and have the partial payments applied.

Note: It is also possible that beginning AP balances could be set up via Create Vendor Invoice from Expense Report. 

Request Customer's Open AP Report

Enter Vendor Invoice documents

Enter unapplied Vendor Payments

(see Outstanding Accounts Payable Items)

NoFuture date
Outstanding Accounts Receivable Items at Initialization

Note: If posting historical invoices from project costs, all project labor and expenses must be imported prior to this step.

Outstanding items will be processed via AR in the future and should always be entered at the document level.  Partially paid items should be entered as original invoice amounts and have the partial payments applied.  Any invoices entered to support the ability to see previously invoiced amounts for project must have cash receipts applied as necessary.

Request Customer's Aged AR Report

Post Historical Invoices

Apply Cash Payments to any paid items

Add unapplied Customer Payments

(see Outstanding Accounts Receivable Items)

NoFuture date
Project costs (Labor and Expense)

Periodic Reporting Needs: monthly, quarterly, annual, inception to date

CP costs by fiscal year for indirect rate application

Invoicing Requirements: (ie labor category, person, cost category)

These posts should be done using the same frequency used when doing the Billing & Revenue Post and Invoice Completion so that the data is consistent in the periodic reports.

Quick Topic - How to load Historical data via expense types and fixed price items - INTERNAL

NoFuture date
Outstanding Bank Reconciliation Items

Enter reconciling items from the bank account reconciliation as of the cutoff date.

Request Customer's Previous month Bank Reconciliation

Enter Journal Entry (See Outstanding Bank Reconciliation Information)

YesBlank or previous date
  • No labels