Historical Data Item
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))
|Yes||Blank 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
|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
|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.
|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)
|Yes||Blank or previous date|