Entering Opening Actuals Balances
- Make sure you have posted outstanding transactions and recognized revenue in your previous job costing program before you set up and use Sage 300 Project and Job Costing.
- Ensure that the contract and projects have an Estimate or Approved status before you enter opening balances.
To enter opening actuals balances:
-
Project and Job Costing > PJC Transactions > Opening Balances.
- Click the New button beside the Document Number field.
- In the Status field, accept New, and then enter information in the other fields above the table.
- Click the Detail button.
The Detail Opening Balance screen appears.
- In the Opening Type field, select Actuals.
- Enter the following general information for the detail you are entering:
- Contract / Project
- Actuals Type (if available)
- Category / Resource (if available)
- Use the detail entry table to enter opening balance amounts for the detail. The columns that appear in the detail table depend on the project style, project type, accounting method, and (for fixed price and cost plus projects) the actuals type.
- In the Actuals column, in the Total Revenue field, enter the amount of revenue recognized in your previous job-costing system for this project level. If you previously entered an opening revenue balance for this project level, the program overwrites the existing revenue amount when you post the opening balance document.
If you use multicurrency, you enter revenue amounts in your functional currency and in the customer currency.
For time and materials projects and fixed price projects that use the billings and costs or accrual-basis accounting method, you enter the amount less any revenue that was not billed in your old system.
- For time and materials projects and for fixed price projects that use the billings and costs or accrual-basis accounting method, also enter for the specified project level:
- The amount of any unbilled revenue in the Remaining To Be Billed field.
- Cost balances (quantity, extended cost, overhead amount, and, for labor categories, the labor amount).
In a multicurrency system, you enter cost amounts in your functional currency.
- Click the Add button to add the detail.
- If you are entering balances for a project that tracks revenue and costs at different levels, enter cost balances for each project category or project resource (depending on the project style), as follows:
- Click the New button beside the Line Number field.
- Select Actuals as the opening type.
- Specify the contract and project, as you did when entering revenue balances.
- Select Cost as the actuals type.
- Enter the cost balances for the category or the resource (quantity, extended cost, overhead amount, and, for labour categories, the labor amount).
- In a multicurrency system, you enter cost amounts in your functional currency.
- Click Add to add the detail.
- If you want to enter additional actuals balances, click the New button beside the Line Number field to start a new detail.
- In the Actuals column, in the Total Revenue field, enter the amount of revenue recognized in your previous job-costing system for this project level. If you previously entered an opening revenue balance for this project level, the program overwrites the existing revenue amount when you post the opening balance document.
- Click Close to return to the Opening Balances screen.
- Click Add (or Save) to add the opening balance document.
You can use the Opening Balances screen to recall the document and modify the opening balances, until you post the document.
- Click Post when you are ready to post the document.
- It is possible that, in your previous job-costing system, revenue was calculated slightly differently than in Project and Job Costing. You should compare the revenue recognized in your previous system to the Actual revenue amounts shown for a contract and its projects and categories in the Contract Maintenance screen.
If the revenue amounts are different, you need to record manual General Ledger entries to adjust the appropriate accounts (revenue, billings, cost of sales, and work in progress accounts). Because opening balances are tracked only in functional currency, you may also need to record manual General Ledger entries to adjust source currency amounts.
- Enter opening balances for stored material, if necessary.
- Enter opening activity statistics.
- Print the Detailed Transactions Report for a record of the posted opening balance documents. For more information, see Detailed Transactions Report.