This "all-in-one" report was designed to provide a number of quick summaries in one place for various business activity. This "report" is actually a combination of distinct sub-reports each with their own code and independent characteristics. This report is based on a report available in the RockSolid software, another ECi Software Solutions product; however, there are some differences. Most of the data included on the report is updated by application services based on a polling interval and not immediately when transactions are processed, so there can be slight delays between processing and the updating of certain totals.

When figures on this report correspond with other reports and inquiries, we indicate that in this topic.

Headings

This report is different from many reports in that it provides summary sections rather than a listing of data in rows and columns. Each section is distinct as described below:

Sales (Branch Totals)

This sub-report lists totals for sales and returns (cash and receivables charge combined for each) with additional totals for reversals. Reversals are not an "undo," but an easy way to create a new transaction to offset the original. Reversals of sales are recorded by the software under "returns." Reversals of credit sales (returns) are recorded in application totals as "sales." This report provides a distinction between a reversal and a regular transaction. The data used for this section are the branch totals ([dbo].[BranchMonthYearTotals]). Branch totals categorize sales and returns differently based on whether they are considered "cash" types (cash, check, bankcard, etc.) or receivables charge. To accurately report the figures on this sub-report, we have to back out the reversals from the "sales" and "returns" figures. Due to this, there will be differences if you compare the sales and returns figures to either the Totals Inquiry or Totals Report; however, the gross sales figures (totals) will match (for the same date(s)).

Gross sales is the sum of the Sales, Sales Reversals, Returns, and Return Reversals figures.

Below is a comparison between the Totals Inquiry for the same branch and date and this report.

Taxes

The "taxes" sub-report lists a summary for tax activity for the selected date(s). Two (2) columns of figures are listed. One column displays the tax amount (if any), the second shows the sales amount (less any tax). Please note: this documentation reflects changes made for releases 12.1.12 and later. Earlier versions differ.

Tax is divided into three (3) categories: non-taxable, tax exempt, and net taxable. Non-taxable sales are sales of products (items) that are not taxable by nature (food, possibly clothing, etc.). Tax exempt usually refers to the status of the customer purchasing the goods (charities, resellers, government entities, etc.). Net taxable refers to sales with taxable items made to customers who are not tax exempt (although, the sales tax rate may be zero). Net taxable doesn't include either exempt or non-taxable sales.

The non-taxable and tax exempt totals for the "tax" column (left) will always be zero. Net taxable will include sales of taxable items to taxable locations as well as sales of "always" taxable items to exempt customers. "Always" taxable items (candy, etc.) are considered taxable regardless of the exempt status of the customer.

Totals are provided for the "tax" and "sales" columns. The "Totals Sales Incl Sales Tax" is the sum of the two (2) totals (gross sales including sales tax). This should normally match the "Gross Sales" reported in the Sales section for the same period. Some non-sale activity can affect sales tax, and not sales totals, such as "use" tax. The total amount in the "Taxes" section is not printed on the Sales Tax Report, but is the sum of the four (4) columns: exempt taxable, net taxable, non-taxable, and tax charged on that report.

Tax totals may not always match the "sales" totals exactly. This can be due to the taxable status of adjustments, credit SKU (coupon items), taxable vs. non-taxable coupons, taxable store-use adjustments, and other reasons. The data used for this section comes from the sales tax totals table ([dbo].[TaxCodeTotals]) which are maintained by day and year-month. The Sales Tax Inquiry and Sales Tax report can be used for comparing to these figures or for additional details.

Journal

This section of the report lists the journal entries created for the date(s) selected for the report. Journal entries aren't generated until the end of the business day usually, so you shouldn't expect to see any results for the current date. The source for the data is the table named "[dbo].[GLJournalDtl]." Journal details are populated regardless of whether any mapping is done and no additional processing is required (other than application services which generate the entries between business days). Please note: this documentation reflects changes made for releases 12.1.12 and later. Earlier versions differ.

If a single branch is selected, the descriptions of the entries list the journal type first ("PS" for Point of Sale, for example) and either the account description (if mapped) or mapping default description (which would provide less detail). Auto-generated entries sometimes include an automatic prefix such as "POS-" or "INVENTORY-." Due to the lack of space available, we replace these with a 2-character prefix indicating the journal type (PS = Point of Sale, AR = Receivables, etc.).

If you run the report with more than one branch selected, the branch ID ("1000," for example) is listed first followed by the journal type prefix ("1000-PS-Account Description," for example).

Journal entries can cause the report output to span additional pages due to the number of details. Longer date periods will generally produce a longer section.

Accounts Receivable

This section summarizes receivables activity that occurred during the date(s) selected. Debits are reflected as positive figures (these increase your overall receivables total) and credits are reflected as negative figures (these reduce your overall receivables total). Please note: this documentation reflects changes made for releases 12.1.12 and later. Earlier versions differ.

•POS A/R Charges (+)

The "POS A/R Charges" figure is the total where receivables charge was a payment method for the selected period and branch(es). This does not include debit adjustments, finance charges assessed, or any other activity. The data source is the same as the Cashiers Report ([dbo].[vw_CashierDocs]) which combines data retrieved from invoice, payments, and other data sources. The source of this data is the branch totals ([dbo].[BranchMonthYearTotals]) .

•POS A/R Returns (-)

This is the sum of credit memos (return sales) where the payment method was receivables charge during the period. The data source is the same as the Cashiers Report ([dbo].[vw_CashierDocs]) which combines data retrieved from invoice, payments, and other data sources. The "credits" figure will only include returns (credit memos) if they were posted on the date in question. Unposted payments, adjustments, and credit memos (returns) are not included. The "Miscellaneous" section does provide a list of any ROA (Received on Account) payments for the date(s) in question. The source of this data is the posting details for the date in question (the database table named, "[dbo].[ARPostingDtl]").

•Credit Adjustments (-)

Credit adjustments made to accounts during the period. These reduce your overall receivables balance. The source is adjustments data ([dbo].[AdjustmentsHdr]).

•Debit Adjustments (+)

Debit adjustments made to accounts during the period. These increase your overall receivables balance. The source is adjustments data ([dbo].[AdjustmentsHdr]).

•Discounts Given (Applied) (-)

The total of any discounts applied during the period. These reduce your overall receivables balance. The source is open credits data ([dbo].[OpenCredits]).

•ROAs (Received on Account) (-)

The total dollar amount of received on account (ROA) processed for the selected date(s). The source of this data is the table named, "[dbo].[MiscPaymentsHdr]," located in the application's database. The Payments transaction found in the Point of Sale area would be the source of this type of transaction.

•Pmts from Payment Entry (-)

This figure (credit) reflects the sum of any payments entered from the Payments Entry or Posting transactions in the Receivables area. The source of this data is the Payments (header) table ([dbo].[PaymentsHdr]).

•AR (Charge) Order Deposits

The total of any customer order deposits paid by receivables charge during the period. Deposits paid by receivables charge create debit adjustments for the account. This figure does not include any cash-type deposits. The source of this data is Miscellaneous Payments, "[dbo].[MiscPaymentsHdr]." The Payments and Customer Orders transactions found in the Point of Sale area would be the source of this type of transaction.

•AR (Charge) Order Deposit Refunds

The total of any customer order deposits paid by receivables charge and subsequently refunded during the period. This does not include any cash-type deposits that were refunded. The Payouts transaction found in the Point of Sale area would be the source of this type of transaction.

•Finance Charges Assessed

The total "new finance charges" from the statement documents for the period in question. Finance charges are only assessed once per month and statement documents are only generated once per billing period. If your report's date range does not include the date that statements were generated, this figure will be zero. New finance charges may be assessed (calculated) on a different date from the statement date; however, the date charges were assessed (calculated) is not used.

•Net Accounts Receivable

This is the sum of the prior figures, debits (+) increase the net and credits (-) decrease the net. This is not the same as the overall receivables balance for the same period which would include prior activity.

Miscellaneous

This section presents a variety of figures for quick reference. Some figures in this section are not based on the date selections.

•Total AR Value

The total current value of AR (Receivables). This is always the current figure and will not change based on date selection. The source of the data is the table named "[dbo].[CustomerMaster]" in the application's database. The calculation is the sum of each customer's outstanding balance plus (+) finance charges and less (-) any credit balance. System type accounts, which normally would not have receivable balances are excluded. If customers are assigned an AR Branch, the assigned branch will be considered based on the branch selections made for the report. This total should match the Total Due from the "Aged Balance" report found in the Receivables area (the report should be run for all accounts (cash and charge), include closed and disabled accounts, and use a filter of "none." Most multi-branch companies combine their receivables; however, there may be differences if your company does not, and runs the report with different branch selections).

•Inventory Value at Cost

The average cost value of inventory for the year-month period of the starting date selected for the report. If the starting month is a prior month, this would be the inventory value at the end of that period. For the current month, it is a month-to-date figure. The data used is provided by the table named "[dbo].[StockValue]" located in the application's database. Items with both positive and negative on-hand are considered. Only items with stock value records for the year-month in question would be included. If the starting date's month matches the current month, this figure should match the "WAVG Value" from the Stock Valuation report available from the Inventory area (the report should be run for ALL groups and sections, filter of "none," including both "SO/Resale" and "Stocked" items, and the branch selections should be the same). For prior months, you would need to have a saved copy of the Stock Valuation at that time.

•Number of Transactions

The number (count) of charge and cash sale transactions processed for the selected date(s). The source of this data is the table named, "[dbo].[BranchMonthYearTotals]," located in the application's database. This matches the information you would see on the Totals Inquiry for the same period.

•Deposits Refunded

The total dollar amount of deposit refunds processed for the selected date(s). The source of this data is the table named, "[dbo].[MiscPaymentsHdr]," located in the application's database. The Payouts transaction found in the Point of Sale area would be the source of this type of transaction.

•Petty Cash

The total dollar amount of petty cash processed for the selected date(s). The source of this data is the table named, "[dbo].[MiscPaymentsHdr]," located in the application's database. The Payouts transaction found in the Point of Sale area would be the source of this type of transaction.

•Check Cashing

The total dollar amount of check cashing processed for the selected date(s). The source of this data is the table named, "[dbo].[MiscPaymentsHdr]," located in the application's database. The Payouts transaction found in the Point of Sale area would be the source of this type of transaction.

•Misc Payments

The total dollar amount of miscellaneous payments processed for the selected date(s). The source of this data is the table named, "[dbo].[MiscPaymentsHdr]," located in the application's database. The Payments transaction found in the Point of Sale area would be the source of this type of transaction.

•Order Deposits (non-AR)*

The total dollar amount of order deposits processed for the selected date(s). The source of this data is the table named, "[dbo].[MiscPaymentsHdr]," located in the application's database. The Payments transaction found in the Point of Sale area would be one source of this type of transaction. Order deposits can also be associated with an order directly at time of processing from the Orders transaction on the Point of Sale menu.

•Order Deposit Refunds (non-AR)*

The total dollar amount of order deposit refunds processed for the selected date(s). The source of this data is the table named, "[dbo].[MiscPaymentsHdr]," located in the application's database. The Payouts transaction found in the Point of Sale area would be one source of this type of transaction. Order deposits can also be associated with an order directly at time of processing from the Orders transaction on the Point of Sale menu.

*Order Deposits and Order Deposit Refunds involving a payment method of receivables charge are listed in the Receivables section and are not included in the totals shown in the Miscellaneous section. Deposits paid by a receivables charge result in a debit adjustment to the customer's account. Deposits applied as payment are listed as totals in the Tenders section below.

Tenders

The "tenders" section summarizes the methods of payments for activity in the selected date period. Some totals listed in this section use the same data view as the Cashiers Report ([dbo].[vw_CashierDocs] which combines data from a variety of sources) as well as the invoice bankcard data ([dbo].[InvoicesBankcard]). Bankcard types and names will vary based on your company's setup. Order deposits as tender use invoice data instead ([dbo].[InvoicesHdr]).

•Cash Tendered

This is the total cash tendered for sales and payments during the period specified (the data source is the same as the Cashiers Report).

•Checks Tendered

This is the total checks tendered for sales and payments during the period specified (the data source is the same as the Cashiers Report).

•Gift Cards

The total for gift cards tendered as payment during the period specified (the data source is the same as the Cashiers Report).

•Order Deposits Used

The total for order deposits used as payment during invoicing (this uses invoice data for the period, not the Cashiers Report).

•Totals by Card Type

For each card type enabled for use, totals will be shown (VISA, MasterCard, etc.).

•Capital One Trade Credit (formerly BlueTarp)

An amount is only shown if Capital One Trade Credit (formerly BlueTarp) was used as a payment method during the selected period; otherwise, no Capital One Trade Credit (formerly BlueTarp) amount is shown. Capital One Trade Credit (formerly BlueTarp Financial) provides receivables-credit services management. The data source is the same as the Cashiers Report for any Capital One Trade Credit (formerly BlueTarp) payments.

Bankcard details are provided by invoice bankcard records. Card types and names may vary from our example. Your company may choose to not accept certain card types.

Selection

This report offers basic date selection only. The context menu associated with the check mark icon () offers access preset date selections.

Branch

Some reports offer branch selection and you can apply branch selection in a number of different ways. For example, invoices can have several branches associated with them. A given invoice might have an entry branch, sales branch, and materials branch that are each different locations. Reports each use branch selections differently based on the type of data being referenced, and for some businesses, branch selection may not apply.

Selected branches are indicated by the checked status of the check box controls next to the branch ID. The Context Marker provides the ability to select the current branch, or select/clear all branch selections. In addition, this can be used to perform branch selection based on a Branch List. Branch lists can be created from the Maintenance area's Database menu. If you choose a branch list, the branches belonging to that list will be selected.

Once a branch list has bee selected, the list name is listed (in parentheses) and the list of branches is disabled. To allow changes, deselect the same list from the Context Marker menu .

Additional Options

A few reports offer additional options for use along with branch selection. These either alter the report format based on how you want branch records presented (consolidation) or allow selection when more than one branch may be indicated within the data being reported (quantity vs. sales branch, for example). For additional information about these "extra" options, click here.

Filter On

There are no filters available for this report.

Sort By

Some reports offer sorting options that may be used in addition to, or in place of, the report's default sorting. Sorting determines the order that information appears on the report, but also can determine how subtotals (when enabled) are done. Typically, subtotals are provided for any sort by selections when subtotals are indicated in the "Totals" panel. If sorting is not available for a report, the panel will be disabled and neither offer nor allow selection.

Two (2) sorting selections may be available; however, both are not always provided. When both are enabled for a report, the top selection is considered the "primary" sort and the bottom is considered a "secondary" sort. Usually, all sort selections are optional. Options for sorting vary by report.

Sort Direction

The menu marker can be used to select the sorting direction, either ascending (the default) or descending. Almost always, data is sorted alphanumerically. This may even be done in some cases when the data being sorted appears to be numeric in value. Date values and some truly numeric values are sorted based on value rather than alphanumerically in certain cases. When alphanumeric data is sorted in ascending order, it is sorted from the left-most character to the right-most character based on the ASCII value. The length in characters typically has no effect on sorting in these cases. Most (not all) symbols and special characters are listed before numerals, numerals typically appear before letters, and upper-case letters are listed before lower-case. When sorted (alphanumerically) in descending order, this ordering is reversed. Sometimes, particularly in the case of items, a "report" or "sorting" key is used in place of item numbers. This allows a company to control sorting while not having to alter their item SKUs. The sorting (report) key isn't always shown (listed) on the report or in other areas where it affects sorting.

Below is a table listing item numbers in ascending vs. descending order. In most cases, items are sorted using their "report sequence" not the item number. Report sequence allows grouping of items in a logical order vs. the alpha-numeric order of the SKU and are commonly used when item numbers represent dimensions or other attributes. For example, you might have two item SKUs of "248" and "2410." The "248" represents an 8 foot (8') length and the "2410" a ten foot (10') length. If these two (2) items were sorted by item SKU, the longer length would appear before the shorter length due to alpha-numeric sorting; however, if you assigned a "report key" to the items of "020408" and "020410" respectively, they would instead be sorted by length. Note the use of leading zeros for each dimension (height, width, and length in this case).

Ascending	Descending
020408SYP	ZITEM
248	BRICK
808957	808957
BRICK	248
ZITEM	020408SYP

Totals Selections

Some reports provide the ability to produce totals, and sometimes, this includes subtotals as well. The "Totals" panel, used with reporting, allows users to select the types of totals they want (when applicable). When totals are offered, the term "grand totals" refers to an overall total appearing at the end of the report. Subtotals are sometimes available, but are usually done based upon your selections in the "Sort By" panel. Subtotals may not be done in cases where no "Sort By" selections have been made; however, this can depend on the report. The totals panel is disabled (appears grayed out) whenever totals are not an option or when the use of totals require additional selections prior to use (such as a "sort by" selection). Totals do not apply to all reports; furthermore, some reports provide totals regardless of selections and do not allow overrides using the "totals" panel.

You are allowed to select one of the following three (3) options when applicable: subtotals, grand total, and none. The "print totals only" check box is available with the first two (2) choices only.

Subtotals

Subtotals indicate that the report should include totals based on the change of certain data. Typically, this "break" for totals is determined by your selections in the "Sort By" panel. Some reports may automatically provide a subtotal level. When the "subtotals" selection is chosen, the report will also include a grand total.

Grand Total

Grand total indicates that the report should include a grand total (ending total) printed on the last page below the last details (when "print totals only" is not checked). Subtotals would not be included when this option is selected.

None

This selection indicates that no totals are to be included when the report is viewed, printed, or processed as a file. If you choose "none," the "print totals only" check box is disabled and the check (if any) is cleared.

Print Totals Only

This check box indicates whether all details should be suppressed when the report is viewed, printed, or processed as a file. In this case, only the grand totals and/or subtotals would be included.