Viewing Summarized Financial Information

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 Reprts > Management Inquiries menu, select Branch Summary Inquiry to display the Branch Summary Inquiry screen.
In the Br/Tr/ALL 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.
With the cursor in the As of Date field, press Enter 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.

Review the following information for each order type:

Column	Description
Order Type	The types of orders for which to view dollar amounts and gross profit: Warehouse – Shows the totals for orders shipped from the selected branch's warehouse. Credits – Shows the totals for credits issued against orders shipped from the selected branch's warehouse. Directs – Shows the totals for orders written at the selected branch but shipped from a vendor's warehouse. Dir Credit – Shows the totals for credits issued against orders written at the selected branch but shipped from a vendor's warehouse. TOTAL – The total amounts for all categories by column.
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.
Inv 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
Whse	The total dollar amount owed to vendors for orders received at the selected branch's warehouse.
Dir	The total dollar amount owed to vendors for orders written at the selected branch but shipped from a vendor's warehouse.
Ret	The total dollar amount of purchases made at the selected branch that were returned to the vendor for credit.
TOT	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.
Avg	The total value of all items in the selected branch's inventory, based on the average cost paid for each item.
Dflt	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, press Esc to exit the screen.