ARC/BSP/Dir Settlement Report

The ARC/BSP/Dir Settlement Report function enables you to generate standard Airlines Reporting Corporation (ARC) reports and also to edit and void ARC items. If you use cash-basis accounting, this function posts the items to the general ledger.

It also enables you to do the same for Direct items (Billing and Settlement [BSP] is not available at this time). The Direct Settlement Type can be used for tickets that you are settling directly with the airline. The Direct Review serves the same function as the ARC Review to settle all non-ARC payables for providers that you do not want to apply payments individually.

You can also use the Direct review if you want to submit and settle travel agent fees (TAFs) by using a report rather than through Interactive Agency Reporting (IAR). To do this, you must interface and invoice TAFs with settlement type D. When you run the report, specify 890 as the provider.

To run the report:

1. On the ARC/BSP submenu, click ARC/BSP/Dir Settlement Report.

   The ARC/BSP/Dir Settlement Report screen appears.

   ARC/BSP/Dir Settlement Report screen

   

2. Complete the screen as follows.

   Note: You do not need to run all of the reports at once. Uncheck any of the boxes under Report Options to skip a report.

   Field	Description
   Use Standard ARC Week	Uncheck this if you want to use a date range other than the standard ARC week (Monday through Sunday). You must select this option if you are on cash-basis and want to post to the general ledger. Note: This option is a time-saver because GlobalWare fills in the correct ending date when you enter the starting date.
   From Date and To Date	Select the starting and ending AP dates for the report. If you selected Standard ARC week, enter any day of the week in the starting date. GlobalWare will automatically fill in the standard ARC week date range that includes that day.
   Period End Date (ARC only)	Enter the last day (Sunday) of the ARC period that you are closing.
   Close Period (ARC only)	Check this box if you want to close the ARC period. This prevents editing of ARC data (ticket number, base fare, and so forth) after you have submitted the ARC report. Note: You can reopen the ARC period by using the System Control function. Specifically, clear the Close ARC Period check box on the System tab of the System Control screen. For details, see System Tab.
   Settlement Plan	Select ARC for ARC settlement items. Select Direct for direct settlement items. A prompt for the provider appears; enter the provider.
   Ticket Location	Select the ticketing location for which you want to run the report, Per, or All. Only the branches to which the employee has access display. If All is selected, all branches to which the user has access are considered. Per prints a report for each location; you do not have the option to edit the data. All prints a report for all locations to which you have access; you do not have the option to edit the data. If you select All, the report sorts by ticket number only, not ticket location. To find and select a ticketing location, click the lookup () button. The Ticket Location screen appears. For details, see Using the Lookup Buttons and Screens.
   Authorization # (ARC only)	Enter a unique numeric identifier, for example, a date in the YYMMDD format. Use a different authorization number each week. This number displays on the ARC weekly sales report.
   Auth Pad % (ARC only)	The formula for the maximum authorization amount is: Cash Sales - (Total Sales * Pad Percentage). Enter the Pad Percentage.
   Summary Report, Cash Sales Report, Credit Sales Report, Voided Tickets Report	Select the reports you want to run.
   Page Break at Subtotals	Select this option to create a new page on the report for each subtotal. Subtotals are generated for every 50 items, per ARC recommendation.

3. Click SEARCH.

   If you searched against a specific ticketing location, the Search Results grid lists items in ticket number order. These results are editable. Continue with step 4. If you selected All or Per for the location, the Send to dialog box appears. Continue with step 5.

4. To edit a field, click in it and type the new value. If the invoice contains discount/markup information, you cannot change the form of payment to plastic.

   To void a record, enter a V in the V column. To un-void a record, remove the V. You cannot un-void an item that has been posted.

   To display additional information about a transaction, press F4.

5. Click PRINT. For information about the report destination options, see Printing Overview. To print the report in batch, click BATCH.

   Note: Printing the report saves any changes you made in the Search Results grid.

6. If you use cash-basis accounting, the Post ARC/BSP/Direct Report screen appears. This screen displays the final totals after printing. To post these totals to the general ledger, click OK. Each time you make a change to the review, you should post the results to the general ledger.

Notes:

• Voids are included on the summary report and the Void Ticket report. On the summary report they are indicated by VOID in the amount column. They are excluded from the Cash and Credit Card Ticket reports.
• The reports are in ticket number order (even if you select All for location).
• The Cash Sales report lists items with form of payment R, A, or C. It also includes all credit/debit memos (document type DCM, DAR, CRE, or AAD), regardless of form of payment. It also includes even exchanges, regardless of FOP, per ARC recommendation. All other items appear on the Credit Sales report (plastic sales and refunds, plastic add-collect and refund-due exchanges).
• On the Cash and Credit Sales reports:
  • Sale is the base fare plus taxes less the exchange amount (that is, net for exchanges), for debit/credit memos it is the net remit.
  • Fare is the base fare (for the new ticket in an exchange, not the net base fare), 0.00 for debit/credit memos, including DARs (which generally have a base fare).
  • Taxes is the total taxes (for the new ticket in an exchange), 0.00 for debit/credit memos, including DARs (which generally have taxes).
  • Commission is the commission (net commission in an exchange).
• For information about how cash-basis ARC and direct items are posted to the general ledger, see Cash-Basis Posting.

Summary Report Totals

On the Summary report totals, the first three columns duplicate ARC’s report. The fourth column is GlobalWare-specific information: accounting information shows how items will post to the general ledger, so it includes discounts/markups and the fare for DARs; and the breakdown of the GlobalWare non-credit card forms of payment.

Net Remit is commission * -1 for all items with form of payment P. For all other items, it is base plus taxes plus penalty minus commission.

Total	Description
Net Cash Tape	Total sales from the Cash Sales report (see "Notes" above).
Less Commissions	Total commissions excluding debit/credit memos.
Net Remittance	Total net remit (also Net Cash Tape minus Less Commissions).
Max Authorized	Net Cash Tape plus Net Credit Tape times the pad amount, subtracted from Net Cash Tape.
x% Pad	Pad amount entered on the dialog box.
Net Cash Tape	Same as above.
Net Credit Tape	Total sales from the Credit Sales report.
Totals	Net Cash Tape plus Net Credit Tape.
Fares	Total base fares less the exchange amount, excluding debit/credit memos.
Taxes	Total taxes (on new ticket for exchanges – that is, not net), excluding debit/credit memos.
Penalties	Total penalties.
Adjustments	Net remit on debit/credit memos.
Totals	Fares plus Taxes plus Penalties plus Adjustments (also same as above).
Cash Sales	Total for cash sales only (excluding refunds and debit/credit memos, including all exchanges).
Cash Refunds	Total for cash straight refunds (refund-due exchanges are included in Cash Sales).
Net Cash Sales	Cash Sales less Cash Refunds.
Adjustments	Same as above.
Net Cash Tape	Cash Sales less Cash Refunds plus Adjustments (also same as above).
Credit Sales	Total for credit sales only (excluding refunds, including all exchanges).
Credit Refunds	Total for credit straight refunds (refund-due exchanges are included in Credit Sales).
Net Credit Tape	Credit Sales less Credit Refunds (also same as above).
Acctg Cash	Total cash sales including discount/markup.
Acctg Comm	Total commission, including discount/markup.
Net Remit	Acctg Cash less Acctg Comm (also same as above).
Cash (for Cash Detail)	Total of total cost field minus discount/markup on items with form of payment C.
Receivable (for Cash Detail)	Total of total cost field minus discount/markup on items with form of payment R.
Agency Plast (for Cash Detail)	Total of total cost field minus discount/markup on items with form of payment A.