Setting up automatic journal entry transaction templates

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Workpapers CS enables you to set up automatic journal entry templates that contain information for a journal entry transaction. The application automatically creates journal entries from this template when you set up or edit the template, change the posting period, preview or print reports, or choose Edit > Recalculate Automatic Journal Entries in the Actions > Enter Transactions screen.

  1. Choose Setup > Transaction Templates.
  2. In the Transaction Detail section, enter information that you want the application to use for journal entries that will be automatically created from this template - journal entry subtype, journal, reference, description, and WP reference. You can also select a Difference or Misstatement for an applicable subtype. For an Adjusting subtype, you can mark the Auto-reverse next period checkbox to have the application reverse the journal entry when advancing to the next posting period.
  3. In the Template tab, enter the template ID (up to 11 alphanumeric characters) and description (up to 50 alphanumeric characters).
  4. In the Type field, select Automatic.
  5. In the Starting period field, select the posting period in which to start creating the transactions from this template. From this posting period and going forward, the application automatically creates transactions dated for the last day of each posting period.
  6. In the Basis field, select the desired balance type.
  7. In the Prior periods field, select the desired prior period treatment to use for transactions created from this template.

    Note: If you set up multiple transaction templates with an Automatic frequency, you can click the Prioritize Automatic Transaction Templates link from any saved template. This opens the Prioritize Automatic Transaction Templates dialog, where you can specify the order in which to calculate the transactions.

  8. Click the Calculation tab.
  9. In the Calculate from grid, select the account number or range of account numbers to include in the calculation. Note that the account selected in the To Account column must be greater than or equal to the account selected in the From Account column. In the Balance Calculation column for each account or range of accounts, select which amounts (year-to-date or single period) to use for the balance calculation.
  10. Choose the method for the application to use when applying the overall balance in the Calculate from grid. If you choose Debit, the application will use the overall balance as is. If you choose Credit, the application will change the sign of the overall balance.
  11. In the Distribute to grid, select the account, percentage, and balance effect (debit or credit) for each distribution. Note that the total percentage for all credit distributions must equal the total percentage for all debit distributions.

    Click here for examples.

    Example 1

    The client's average cost of goods sold is 40% of sales, and the relevant range of sales accounts is 401 through 450. The application will debit account 510 (COGS) and create an offsetting credit to account 130 (inventory).

    example 1

    Example 2

    The client pays $1,000 for maintenance each week to Gary Hansen Lawn Maintenance, and the initial debit would be expensed to Location 1 (account 1-663). Because only 40% is actually attributable to the first location, the automatic calculation should credit that location for 60% of the total, and distribute it among the accounts for the other locations (20% to 2-663, 20% to 3-663, 10% to 4-663, 5% to 5-663, and 5% to 6-663).

  12. Click Enter to save the template.

Related topics

Setting up and using transaction templates

Share This