To view summarized financial information for one or more branches or territories within your company, run the Branch Summary Inquiry. You can review your total sales, accounts receivable, accounts payable, purchases, and inventory as of a specific date. This inquiry gives you the total picture of how your business is doing.
To view only sales information, run the Branch Sales Inquiry. This inquiry compiles more quickly because it does not include accounting or inventory statistics.
To view a summary of a branch's financial information:
From the Reports > Management Inquiries menu, select Branch Summary Inquiry to display the Branch Summary Inquiry window.
In the Branch field, enter the codes that identify the branches or territories for which to view financial information. Enter commas between codes. To view financial information for all branches, enter ALL.
In the Bookings field, enter one of the following values:
Original – Shows the totals for all sales orders written during the specified period. This includes orders that were bids only.
Note: This total may also include amounts entered in error. For example, if the sales representative entered a price of $10000, but meant to enter $100.00, the $10,000 amount is reflected in the original booking total, even if the sales representative later corrects the total to be $100.00.
Net – Shows the totals for all sales orders written during the specified period, including any adjustments made to those orders since they were first written.
In the As Of Date field, enter the date as of which to view financial information.
Click Update to display financial information based on your selection criteria.
Note: You can view the progress of the data compilation on the status bar. Compiling may take a few minutes.
In the Order Information section, review the following information for each category:
Column | Description |
<category> | The types of orders for which to view dollar amounts and gross profit:
|
MTD Booked $ | The total dollar amount of all sales orders written during the specified period. This shows all items ever entered on an order even if the price was changed or the order was canceled. |
GP% | The percentage of the total dollar amount the selected branch would receive as gross profit during the specified period if all written sales orders were invoiced. |
Sales $ | The total dollar amount of all sales orders actually invoiced or shipped during the specified period. |
GP $ | The total dollar amount the selected branch receives as profit from all sales orders actually invoiced or shipped during the specified period. |
GP% | The percentage of the total dollar amount the selected branch receives as gross profit during the specified period for all sales orders invoiced or shipped during the specified period. |
Open $ | The total dollar amount of all open sales orders, not only those that have not been shipped as of the specified date. |
GP % | The percentage of the total dollar amount the selected branch would receive as gross profit during the specified period if all open sales orders were invoiced. |
In the Accounts Receivable area, review the following information, as needed:
Field | Description |
Open | The total dollar amount of all invoiced sales orders. |
Cash Receipts | The total dollar amount of all payments received. |
Invoice to print | The total dollar amount of sales orders that have not been billed to the customer. |
In the Accounts Payable area, review the following information, as needed:
Field | Description |
Open | The total dollar amount of invoices that have not yet been paid. |
Unbilled | The total dollar amount owed to vendors for purchases the branch has made for which you have not yet been billed. |
TOTAL | The total dollar amount of all accounts payable, including both open and unbilled payables. |
In the Open Purchases area, review the following information, as needed:
Field | Description |
Warehouse | The total dollar amount owed to vendors for orders received at the selected branch's warehouse. |
Directs | The total dollar amount owed to vendors for orders written at the selected branch but shipped from a vendor's warehouse. |
Returns | The total dollar amount of purchases made at the selected branch that were returned to the vendor for credit. |
TOTAL | The total dollar amount of open warehouse and direct shipment purchases, minus returns. |
In the Inventory Valuation area, review the following information, as needed:
Field | Description |
G/L | The general ledger balance for the selected branch's inventory. |
Average | The total value of all items in the selected branch's inventory, based on the average cost paid for each item. |
Default | The value of all items in the branch's inventory, based on replacement cost. |
Last | The value of the selected branch's inventory, based on the last price paid for the items. |
COGS | The dollar amount of your cost of goods sold. |
When you have finished reviewing information, exit the window.
See Also: