Troubleshooting Common Accounting Issues

This guide covers the most frequently encountered accounting issues in AccuArk and how to resolve them. Each section describes the symptom, explains the likely cause, and provides step-by-step instructions to fix it.

1. Trial Balance Shows “Out of Balance”

Symptom: The Trial Balance report shows that total debits do not equal total credits.

Likely Cause: Account balances in the chart_master table have become stale or inconsistent. This can happen if a database operation was interrupted or if data was modified outside of AccuArk.

Solution:

1. Navigate to Business > Chart of Accounts
2. Right-click anywhere in the accounts grid
3. Select Repair Balances from the context menu
4. Wait for the process to complete — it recalculates every account's balance, total debits, and total credits from the complete transaction history
5. Reopen the Trial Balance to verify it now balances

Repair Balances requires the FIN_REPAIR_BALANCES permission. If you do not see this option in the context menu, contact your administrator.

2. Transaction Not Appearing in an Account

Symptom: You created a transaction but it does not appear in the Account Transactions list for the expected account.

Likely Cause: The date filter or location filter is excluding the transaction.

Solution:

1. Open Business > Account Transactions
2. Select the account from the account dropdown
3. Check the date filter — Click the date range dropdown and select All Dates to remove any date restriction. If the transaction appears after selecting All Dates, the original date filter was excluding it.
4. Check the location filter — Ensure the Location dropdown is set to All Locations or to the specific location where the transaction was posted. A transaction posted to Location A will not appear when filtering by Location B.
5. Verify the account side — If the transaction was a journal entry, confirm which account was on the debit side and which was on the credit side. The transaction appears in both accounts' transaction lists, but if you are looking at the wrong account, you will not find it.

If the transaction still does not appear after clearing all filters, verify that it was saved successfully by checking the audit trail or searching by transaction number.

3. Cannot Create Transaction — Closed Period Error

Symptom: When saving a transaction, AccuArk displays an error message stating that the transaction date falls in a closed accounting period.

Likely Cause: The accounting period that contains the transaction date has been closed or locked by an administrator.

Solution:

• Option A: Change the transaction date — If appropriate, change the transaction date to a date that falls within an open period. For example, if January is closed but February is open, use a February date.
• Option B: Ask an administrator to reopen the period — A user with the FIN_CLOSE_PERIOD permission can navigate to Business > Accounting Periods and change the period status from Closed back to Open. Note that Locked periods cannot be reopened.

Before asking to reopen a period, consider whether the entry can be recorded in the current open period instead. Reopening a closed period should be done sparingly and only when corrections to the original period are genuinely necessary.

4. Financial Dashboard Showing Unexpected Numbers

Symptom: The Financial Dashboard shows cash balances, AP/AR totals, or profit figures that do not match what you expect.

Likely Cause: The location filter is set to a specific location rather than All Locations, or the data has not been refreshed after recent transactions.

Solution:

1. Verify the location filter — Check the Location dropdown at the top of the Financial Dashboard. If it is set to a specific location, the dashboard only shows data for that location. Switch to All Locations to see the full business picture.
2. Click Refresh — The dashboard loads data when it opens. If transactions have been created since the dashboard was opened, click the Refresh button in the toolbar to reload all panels with current data.
3. Check the time period — Some dashboard panels (such as Profit & Loss summary) display data for a specific date range. Verify that the date range matches your expectations.

5. Recurring Journal Entry Not Processing

Symptom: A recurring journal template exists but no entries are being generated on the expected dates.

Likely Cause: The template may be inactive, the next run date may not have passed yet, or AccuArk may not have been started since the date became due.

Solution:

1. Navigate to Business > Recurring Journals
2. Locate the template in the grid and check:
   • Status — Is it Active? Inactive templates (shown in gray) will not generate entries regardless of their schedule. Select the template and click Toggle Active to reactivate it.
   • Next Run Date — Has this date passed? If the next run date is in the future, the template will not process until that date arrives.
   • End Date — If the template has an end date and that date has passed, no more entries will be generated.
3. Restart AccuArk — Recurring journal processing occurs at application startup. If AccuArk has been running continuously since before the next run date, close and reopen it to trigger processing.

After processing, check the Account Transactions view for the newly generated entry. Its transaction number and description will reference the recurring template.

6. Account Balance Seems Wrong

Symptom: An account's balance in the Chart of Accounts does not match the total you expect when you mentally add up the transactions.

Likely Cause: The cached balance in the chart_master table may be out of sync with the actual transaction data. This is rare under normal operation but can occur after database maintenance or interrupted transactions.

Solution:

1. Navigate to Business > Chart of Accounts
2. Right-click anywhere in the grid
3. Select Repair Balances
4. The system recalculates every account's balance by summing all transaction debits and credits from the account_transactions table
5. After completion, the account balances in the grid will reflect the actual transaction data

If the balance still seems wrong after Repair Balances, open the Account Transactions view for that account, select All Dates and All Locations, and manually review the entries. Look for transactions that may have been posted to the wrong account or with incorrect amounts.

7. Cannot Edit a Transaction (Yellow Row)

Symptom: A transaction row appears highlighted in yellow in the Account Transactions view. Double-clicking it does not open an edit form, or the edit form opens in read-only mode.

Likely Cause: The transaction is system-generated. System-generated transactions are created automatically by AccuArk (for example, from invoice payments, bill payments, or recurring journal processing) and are marked as read-only to preserve data integrity.

Solution:

System-generated transactions cannot be edited or deleted directly. Instead:

1. Create an adjusting journal entry — Navigate to Business > Journal Entry and create a new entry that offsets the incorrect amounts. For example, if a system-generated entry debited the wrong expense account for $100, create a journal entry that credits that account for $100 and debits the correct account for $100.
2. Reference the original — In the description of your adjusting entry, note the original transaction number (for example, “Adjustment for TXN-2026-00042”) so the audit trail is clear.

This approach preserves the original system-generated transaction while correcting the net effect on account balances.

8. Balance Sheet Is Out of Balance

Symptom: The Balance Sheet report shows that total assets do not equal total liabilities plus equity.

Likely Cause: One or more accounts may have an incorrect account class assignment, or account balances may be stale.

Solution:

1. Run Repair Balances first — Navigate to Business > Chart of Accounts, right-click, and select Repair Balances. This resolves most Balance Sheet discrepancies caused by stale cached balances.
2. Verify account class assignments — Open the Chart of Accounts and review each account's assigned class:
   • Asset accounts should be in an Asset class
   • Liability accounts should be in a Liability class
   • Equity accounts should be in an Equity class
   • Revenue and Expense accounts should be in their respective classes
   • If an account is assigned to the wrong class (for example, a liability account classified as an asset), the Balance Sheet will be incorrect. Edit the account and change its class assignment.
3. Check for unclassified accounts — If any account does not have a class assigned, it may be excluded from the Balance Sheet entirely, causing an imbalance.
4. Reopen the Balance Sheet — After making corrections, close and reopen the Balance Sheet report to verify it now balances.

If the Balance Sheet remains out of balance after these steps, run the Trial Balance report. A balanced Trial Balance with an unbalanced Balance Sheet almost always indicates a classification issue rather than a data issue.