CenterPoint Accounting for Agriculture - How to Find Transaction Activity with Missing Production Details

 

Document #:	3312	Product:	CenterPoint® Accounting for Agriculture

 

The General Ledger Account Activity report can be used to create a favorite report grouped by production details. The report gives an overview of each production detail and the accounts allocated to the production detail. If you have expense accounts that list at the top of the report under no production detail heading, the accounts have activity with unallocated production detail.

Create the General Ledger Account Activity Report:

1. Select Reports > Reports > Transaction Reports > General Ledger > General Ledger Account Activity.
2. Under Report Selections, select the Transaction Date span you wish to review.
3. In the Account Type report selection, click the down-arrow and select one account type at a time, such as Expenses, by moving your selection to the right side of the screen and clicking OK.
4. Preview the report.
5. On the left side of the screen, select the Group & Sort tab.
6. Click on the Available tab and select Production Year, Profit Center and Production Center (if you are using Production Centers).
7. On the left side of the screen, select the General tab.
8. Select Show Totals Only.
9. Click Refresh.
10. Select Add to Favorites (star icon) to name the report and save to your favorites.

    If you are using distributions with a timing of "later", the report begins with a section of no production details. A row for each account using distributions is listed. The Debits should equal the Credits. This is expected and correct.

    If you have expense accounts with a debit only and no production year or no profit center, the accounts have activity with unallocated details.

    In the example below, the Gas expense has 2017 assigned but no profit center.

    Drill-down does not work on a Show Totals Only report, but you can select the General tab again and uncheck Show Totals Only to see transaction detail and drill-down.

 

How do I fix unallocated account activity?

In many cases, you can assign the missing detail in the drill-down of the transaction within the report. If it is an entry you do not wish to edit or there are multiple entries, use a general journal entry.

A general journal can be done to reverse the detail assigned originally and assign the details as needed in the general journal grid.

1. Select Processes > General Journal Entries.
2. Select the Company/Fund and Date you wish to enter the general journal for. Name is not needed.
3. In the Transaction Type box, select General Journal (Accrual).
4. In the grid select the Account with the missing production detail. Note: From the example General Ledger Account Activity report above, we will fix the Gas Expense with no profit center for $725.00.
5. Additional columns will be needed in the general journal grid. Right-click your mouse over the blue row and select Add/Remove Columns. Add Production Year, Profit Center, Production Center and Distribution.
6. An increase to an expense is a debit so we will use the same details it has now and credit the amount. Enter $725.00 in the Credits column and enter 2017 in the Production Year.

7. On the next row select the same account. Enter the same amount in the Debits column. The Distribution box should be checked on this row. When the general journal is saved, the default distribution for this account is applied to the amount.
8. Select the appropriate Production detail.
9. If the account does not have a default distribution or if you are not using distributions, you can use the general journal grid to assign the details as needed on individual rows.The general journal can include as many rows as needed to divide the total unallocated amount to the necessary production details.
10. The Debit Total must equal the Credit Total to save the entry.

 

11. Click Save to record the production detail detail assignment. Rerunning the report will show the accounts with equal debits and credits in the top section of no production detail.

See Also