Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Example scenario: If a member of the Electrical department, in the Residential division, works on a Job in the Commercial division for 30 of 40 hours in a week, the costs of the member's benefits and tools costs for all 40 hours go to the Electrical department but 30 hours' worth of revenue is generated in the Commercial division. As a result, the division has profit, even with the Cost of Goods Sold amounts that it carries, and the Electrical department does not. If this happens often, financial reports can start to indicate that the Electrical department and even the Residential division is not contributing to profitability.

Note
At a minimum, you MUST assign an All - Default: REQUIRED account for each origin/account type combination in the account tree. However, this account would only be used if you did not have accounts assigned anywhere in the individual Division tree levels.

...

The Payroll And Overhead Offset Accounts Setup window provides a lot of flexibility in setting up accounts. Before you begin assigning accounts, jot down how general or specific you want charges, expenses, and so on to be charged to what accounts, for which departments. Perhaps you could print the origin/account type diagrams above, and mark which levels for which you will assign accounts. If necessary, organize and enter your accounts in a spreadsheet, and use that as your source when you to enter them into the system.
Setup requirements for account types
Please review the following setup requirements for setting up offset accounts.

  • Overhead Offset
    You can enter accounts for individual overhead detail codes (Job Cost) only if the Payroll Overhead Detail Distribution checkbox in the Posting Options window is marked. You can still assign a default account that would be used for all for overhead codes.
  • Travel Offset Accounts and Expense Offset Accounts
    You can enter accounts for travel and expenses only if Signature TimeTrack is registered and the Create Expense/Travel Transactions option is set. This applies to all origins.

...

To keep better track of which accounts were assigned, we recommend you periodically print the Signature Payroll and Offset Accounts list. In the Payroll and Overhead Offset Accounts window, select on the printer button that appears at the bottom left of the window. Complete the Report Destination window to print the report.

...

  1. In the Payroll and Overhead Offset Accounts window, select the Origin and Account Type.
  2. Locate the Division for which you want to assign accounts. Use the tree view to navigate as far down the tree as you desire, until you hit the level at which you want to assign an account. To save time, you can navigate the tree using arrow keys. When you get to a level/node that for which you can assign accounts, the account field at the bottom of the window is enabled. Some origin/account type trees do not go as deep as others. For example, for the travel offset account type, you can specify accounts at the Pay Code level. For the expense account type, you can assign accounts one level deeper, at the Cost Element level.
  3. You can select an account in one of two ways:
    • Double-click on the node to which you are assigning the account (ex. Pay Code). The Accounts window opens. Select an account, then select click Select. The account displays in the account number in the account field. The account is saved automatically. - OR -
    • Highlight the node in the tree, then enter the account manually in the account field at the bottom of the window. When finished, select the Save button. (You only need to select Save when you enter accounts manually.) 

      Note

      Assign more accounts; remember to assign at least an All - Default: REQUIRED account for each origin/account type combination. If you close the window without having assigned Default accounts, a missing required account number message will display.

...

  1. Highlight the node in the tree, then enter the account manually in the account field at the bottom of the window.
  2. In the account field, type a new account, then Tab. Select Add when prompted to create the account.
  3. Select the type of account you want to create (Posting, Fixed, or Variable). The Account Maintenance window opens.
  4. Complete the fields on the Account Maintenance window, including a Description. When finished, select Save.

...

  1. Select Microsoft Dynamics GP > Tools > Setup > Job Cost > Account Setup > Invoice Accounts.
  2. Select a division from the drop-down list. 

    Note

    The invoice posting accounts are updated when you post invoices for a job assigned to this division. You must enter accounts for each division.

  3. Select an invoice posting option and the appropriate general ledger posting accounts based on the invoice posting option you selected:


    Option 1 - Single sales accountOption 2 - Sales account for each cost element/code

    Select this option if...

    ...you You use the percentage-of-completion or completed contract revenue recognition method.
    The single sales account method designates that one general ledger account updates when you post Job Cost invoices to the selected division.

    When an invoice is posted with this option, the typical general ledger entry debits an accounts receivable account and credits a progress billings account.

    ...you You want to update designated sales posting accounts assigned to each cost element when you post Job Cost invoices to the selected division.

    Typically, you use this method to recognize revenue when issuing invoices. This option allows you to compare amounts billed for each cost element. For example, if you want to know the total amount of labor sales, all labor sales amounts are posted to one general ledger account. Each sale from a cost element posts to its specific account.

    Note

    You cannot select option 2 if you are using the percentage-of-completion revenue recognition method.

    Sales account to use when posting Job Cost invoices

    Progress Billings
    Enter the general ledger account credited when invoices are posted for jobs. This is for percentage-of-completion or closed jobs journal entries. This account is the offset to the progress billings account and should be the same as the account entered in the Division Accounts Setup window (Microsoft Dynamics GP > Tools > Setup > Job Cost > Account Setup > Division Accounts).

    You can enter one sales account if you recognize revenue when invoices post and you want all sales amounts posted to the same general ledger account.

    Cost Element Sales Accounts
    Enter a sales account for each cost element. These accounts are updated for each cost element affected by an invoice:

    • Labor
    • Materials/Equip
    • User-Defined 2
    • Subcontractors
    • Travel
    • Startup
    • Other
    • User-Defined 7
    • User-Defined 8
  4. Enter receivables and commission accounts:
    • Accounts receivable
      The general ledger account debited when you post accounts receivable amounts for Job Cost invoices.
    • Retention accounts receivable
      The general ledger account debited when you post retention accounts receivable amounts for Job Cost invoices.
    • Commissions payable
      The general ledger account credited when you post commissions payable amounts for Job Cost invoices. Your setup selections in Receivables Management determine commission amounts.
    • Commissions expense
      The general ledger account debited when you post commissions expense amounts for Job Cost invoices.
  5. Mark the Use a sales account for each bill code checkbox if you want to use a sales account for each bill code at the job level and during job invoice entry. You cannot use this option if there are unposted invoices.
  6. Select Save.
  7. To print the Invoice Accounts report, select Print.

...