Dashboard Component Overviews

Use the Summary - Balances dashboard to view a chart or grid representation of AP, AR, cash, inventory value, and time ticket total balances. Amounts on this dashboard object are calculated as follows:

• The Cash Balance amount sums the YTD Balance for all GL accounts with an account type of 5 or 10 (including unposted GL journal entries), minus the Grand Total Net Paid column on the AP Edit Register when checks are prepared, plus the Grand Total of Debits on the AR Cash Receipts Journal.

  If you entered payments in AR or SO transactions, these are included as well, but they are all rolled into the amount on the AR Cash Receipts Journal.

• The Inventory Value amount is the Extended Cost Grand Total on the IN Valuation Report for the current date.
• The AR Balance amount is the Amount Grand Total on the AR Aged Trial Balance report for the current date, minus the Debits Grand Total on the AR Cash Receipts Journal, plus the Invc Total Grand Total on the AR Sales Journal, minus the Taxable, Nontaxable, Freight, Misc, and Sales Tax Grand Total amounts on the AR Misc Credits Journal.

  This amount does not include SO Invoice amounts.

• The AP Balance amount is the Amount Grand Total on the AP Aged Trial Balance report for the current date, plus the Total Grand Total on the AP Purchases Journal, minus the Total Grand Total on the AP Misc Debits Journal, minus the Grand Total Net Paid on the AP Edit Register when checks are prepared.

  Prepaid invoices are not included on the AP Aged Trial Balance report—if you have any prepaid invoices, subtract that amount. Print the AP Open Invoice Report for prepaid invoices to see any prepaid totals.

• The Time Tickets amount is the Amt Grand Total from the Project Costing Time Ticket Journal.

You can adjust the Workstation Date field parameter and refresh the dashboard to display the analysis using a different starting date.

Use the Summary - Sales and Profit dashboard to view a chart or grid representation of sales, profit, and variance amounts for the selected budget and timeframe. You can adjust the Budget field parameter to a different account defined in the GL Account Budgets and Forecasts function. You can also adjust the Time Frame field parameter to a Daily, Monthly, or Yearly timeframe. And finally, you can adjust the Workstation Date field parameter and refresh the dashboard to display the analysis using a different starting date.

Amounts on this dashboard object are calculated as follows:

• The Actual Daily Sales amount is the sum of unposted GL Journal entries, unposted AR transactions, and unposted SO transactions.

  Unposted GL Journal entries include transactions with a current transaction date for accounts with account types between 500 and 510. Entries to accounts where the account type = 505 should be subtracted when the entry is a debit, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

  Unposted AR transactions do not include tax, freight, and misc amounts, only the taxable and nontaxable totals. Add invoice amounts and subtract credit memos, regardless of transaction date.

  Unposted SO transactions include those with a status of Invoice or Verified. As with unposted AR transactions, these transactions do not include tax, freight, and misc amounts, only include taxable and nontaxable totals. Add invoice amounts and subtract credit memos, regardless of transaction date.

• The Budget Daily Sales amount is the sum of the current period budget balances of all GL accounts with an account type between 500 and 510, divided by 30 (the average number of days in a month).

  Entries to accounts where the account type = 505 should be subtracted when the entry is a debit, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

• The Variance Daily Sales amount is the Budget Daily Sales amount subtracted from the Actual Daily Sales Amount.
• The Actual Daily Gross Profit amount is similar to the Actual Daily Sales above, with these exceptions: subtract the total extended cost from all line items on AR and SO transactions that are included, and subtract unposted GL journal entries with a current transaction date that are made to accounts for the account type = 600 (entries to these accounts are normally debits).
• The Budget Daily Gross Profit amount is the sum of the current period budget balances of all GL accounts with an account type between 500 and 510, minus the current period budget balance of all GL accounts with an account type = 600. This result is then divided by 30 (the average number of days in a month) to give the amount shown in the Budget Daily Gross Profit field.

  Entries to accounts where the account type = 505 should be subtracted when the entry is a debit, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

• The Variance Daily Gross Profit amount is the Budget Daily Sales Profit subtracted from the Actual Daily Gross Profit.
• The Actual Monthly Sales amount is the sum of actual current period balances, unposted AR transactions, and unposted SO transactions.

  Actual current period balances include GL entries already posted to master plus unposted GL Journal entries for the current period that are made to accounts that have an account type between 500 and 510. Entries made to accounts with an account type of 505 should be subtracted when the entry is a debit, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

  Unposted AR transactions do not include tax, freight, and misc amounts, only the taxable and nontaxable totals. Add invoice amounts and subtract credit memos, regardless of transaction date.

  Unposted SO transactions include those with a status of Invoice, Verified, or Credit Memo. As with unposted AR transactions, these transactions do not include tax, freight, and misc amounts, only include taxable and nontaxable totals. Add invoice amounts and subtract credit memos, regardless of transaction date.

• The Budget Monthly Sales amount is the sum of the current period budget balances of all GL accounts with an account type between 500 and 510.

  Entries to accounts where the account type = 505 should be subtracted when the entry is a debit, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

  This value is not divided by 30 as it represents a monthly, not daily, value.

• The Variance Monthly Sales amount is the Budget Monthly Sales subtracted from the Actual Monthly Sales.
• The Actual Monthly Gross Profit amount is similar to the Actual Monthly Sales above, with these exceptions: subtract the total extended cost of all line items on included AR and SO transactions, and subtract the actual current period balance and unposted GL Journal entries for the current period that are made to accounts with an account type = 600 (entries to these accounts are normally debits.)
• The Budget Monthly Gross Profit amount is the sum of the current period budget balances of all GL accounts with an account type between 500 and 510, minus the current period budget balance of all GL accounts with an account type = 600.

  Entries to accounts where the account type = 505 should be subtracted when the entry is a debit, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

  This value is not divided by 30 as it represents a monthly, not daily, value

• The Variance Monthly Gross Profit amount is the Budget Monthly Gross Profit subtracted from the Actual Monthly Gross Profit.
• The Actual Yearly Sales amount is the sum of actual YTD balances, unposted AR transactions, and unposted SO transactions.

  Actual YTD balances include GL entries already posted to master plus unposted GL Journal entries for the current period that are made to accounts that have an account type between 500 and 510. Entries made to accounts with an account type of 505 should be subtracted when the entry is a debit, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

  Unposted AR transactions do not include tax, freight, and misc amounts, only the taxable and nontaxable totals. Add invoice amounts and subtract credit memos, regardless of transaction date.

  Unposted SO transactions include those with a status of Invoice, Verified, or Credit Memo. As with unposted AR transactions, these transactions do not include tax, freight, and misc amounts, only include taxable and nontaxable totals. Add invoice amounts and subtract credit memos, regardless of transaction date.

• The Budget Yearly Sales amount is the sum of the YTD budget balances of all GL accounts with an account type between 500 and 510.

  The balance from accounts with an account type = 505 should be subtracted, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

• The Variance Yearly Sales amount is the Budget Yearly Sales subtracted from the Actual Yearly Sales.
• The Actual Yearly Gross Profit amount is similar to the Actual Yearly Sales above, with these exceptions: subtract the total extended cost of all line items on included AR and SO transactions, and subtract the actual YTD balance and unposted GL Journal entries made to accounts with an account type = 600 (entries to these accounts are normally debits.)
• The Budget Yearly Gross Profit amount is the sum of the YTD budget balances of all GL accounts with an account type are between 500 and 510, minus the current period budget balance of all GL accounts with an account type = 600.

  Entries to accounts where the account type = 505 should be subtracted when the entry is a debit, since that account type has a normal debit balance. Accounts with types of 500 and 510 have normal credit balances.

• The Variance Yearly Gross Profit amount is the Budget Yearly Gross Profit subtracted from the Actual Yearly Gross Profit.

Use the Summary - Ratio Analysis dashboard to view a grid representation of the current actual and targeted debt to equity ratio.

Amounts on this dashboard object are calculated as follows:

• The Actual Quick Ratio is the same number that appears as the Quick Ratio on the “ratio” financial statement in Traverse when you run it for the current period.
• You can also calculate the quick ratio using this formula:
• (Current Assets - Inventories) / Current Liabilities
• The Target Quick Ratio is always 2.20:1.
• The Actual Current Ratio is the same number that appears as the Current Ratio on the “ratio” financial statement in Traverse when you run it for the current period.
• The Target Current Ratio is always 10.00:1.
• The Actual Debt/Equity Ratio is the same number that appears as the Debt To Equity ratio on the “ratio” financial statement in Traverse when you run it for the current period.
• The Target Debt/Equity Ratio is always .75:1.

You can adjust the Workstation Date field parameter and refresh the dashboard to display the analysis using a different starting date.

Use the Summary - Sales Orders dashboard to view a chart or grid representation of the unshipped, shipped, and returned sales orders on record.

Amounts on this dashboard object are calculated as follows:

• The Unshipped Orders amount is the sum of the invoice total fields on orders that have a status of New or Backordered.
• The Shipped Orders amount is the sum of the invoice total fields on orders that have a status of Invoiced or Verified.
• The Returned Orders amount is the sum of the invoice total fields on orders that have a status of CR Memo.

Use the IN Slow/Fast Movement dashboard to view a chart or grid representation of fast-moving and slow-moving inventory items. You can adjust the Detail or Summary field parameter to view either a detailed or summary representation. You can also adjust the Number of Items field parameter to a different number to customize the number of items to include. You can adjust the Slow or Fast field parameter to view either slow or fast moving items. You can adjust to display information for period-to-date or year-to-date from the Time Frame field parameter. You can also adjust whether to view volume, sales, or turns by adjusting the Volume, Sales, or Turns field parameter. And finally, you can adjust the Workstation Date field parameter and refresh the dashboard to display the analysis using a different starting date.

Field Calculations

• PTD Sales = total sold for the current period - total returned
• YTD Sales = total sold for the current year - total returned
• PTD Volume = total quantity sold for the current period - total returned
• YTD Volume = total quantitiy sold for the current year - total returned
• Turns = Cost of Goods Sold ÷ Average Inventory for the Period