Internal - Upstream Revenue - Suspense Subledger
The subledger data for suspense is held in the Owner Amounts screen. This screen changes balances as transfers, releases, and suspense are done in the Division Order module. There are two ways to create subledger data that ties back to an accounting month end. The following outlines steps to create subledger data.
📘 Instructions
Do the following after the last Company Process Control run of an accounting month
Navigate to Disbursements>Owner Amounts
Clear all filters on the grid
Make sure all accounting dates are selected using Choose Dates, if that option is available
Search for a Status of “Suspense”
This should pull back a balance that ties to the general ledger after the final Company Process Control run of the accounting month
Export the data to create a subledger
Repeat this for each company revenue is processed in
Do the following if you need to create a subledger for an accounting, but later Company Process Controls have been run:
Pull historical suspense balances:
Navigate to Disbursements>DO Journal Results
Search for a Status of “Suspense”
Search for the Suspense GL Account(s)
Export the data
Pull in voided owner payments to subledger data:
Navigate to Financial Inquiry>Transaction Inquiry
Search for the Suspense Account(s) and voucher number with “%v%”
Export the data
Combine to the 2 data sets for a complete subledger
Option 1 is best practice.