Circulation User Manual
NavigaSupportSetup Manual
  • Circulation User Manual
  • ❶ Introduction
    • Circulation Overview
      • The Basic Concept
      • Summary
    • Application Launcher
    • Navigating the Graphical Interfaces
    • Viewing and Printing Reports
      • The Report Viewer
      • Filtering and Other Options
    • Personalization
    • Mapping
  • ❷ Customer Service
    • Find
    • Documents
    • Alerts
    • Contacts
    • Mapping
    • Viewing Customer Information
      • Subscription
      • Address
      • Occupant
      • Contact
      • Demographics
      • Financial
      • Rate Changes
      • Rates
      • Miscellaneous
      • Transactions
      • Rewards
      • Merchandise
      • Subscriber Info
    • Address and Occupant
    • Transactions
      • Day Pass
      • New Start
      • Stop
      • Restart
      • Complaint
      • Billing Change
      • Delivery Schedule
      • Route/Mail Reassignment
      • Move
      • Temporary Address
      • End Temporary Address
      • Payment
      • Cancel Payment
      • Transfer
      • Refund
      • Refund Write-off
      • Grace WriteOff
      • Notes
      • Delivery Placement
      • Contact
      • Combo Change
      • End Combo
      • Modifying Transactions
      • A Note About Rerating Subscribers
    • Messages
    • Tasks
  • ❸ Route Service
    • Finding Routes
    • Mapping
    • Viewing Route Information
    • Transactions
    • Draw Management
    • Account Information
    • Messages
    • Route Service Reports
    • Setup
      • Route Sequence
      • Route Setup Utility
      • Router Utility
      • Rerouting
      • Substitute Draw
      • Truck Time
    • Account Services
    • Distribution Maintenance
    • Utilities
      • Suspend Route
      • Insert Base and Draw Exports
      • Burt Export
      • GMA/SAM Export
      • Draw Forecast Export
      • Drop Time Import
      • Truck Dock Import
      • Single Copy Draw Import
      • Router Import
      • Max Return
      • Drop Time Entry
      • Truck Validation
      • Truck Check
      • Deadline Override
      • Reseq Drop Order
      • Reseq Depart Order
      • Draw Change Lockout
  • ❹ Publishing
    • Introduction to Publishing
    • Edition Override
    • Multi-Pack Override
    • Edition List Setup
    • Import Bundle Sizes
    • Carrier Mail Export
    • Set Sub-Product Draw
    • Start Publishing Run
    • Press Room Report
    • Transaction Processing
    • Undo Final Tran Proc
    • Distribution Menu
      • Daily Draw Worksheet
      • Edition Drawsheet
      • Enter Bundle Info
      • Stacker Interface
      • Bundle Tops
      • Truck Manifest
      • Route Labels
      • Status/Collect Cards
      • Prev Delivery Labels
      • Adv Reconciliation
      • Single Copy Receipts
    • Mail Menu
      • Print Labels
      • Daily PO Report
      • Finnish Post Export
    • DM Report
    • End Publ Run
    • Press Room Entry
    • Press Room Import
    • Press Room Audit
    • Resupply Documents
    • Publishing Run Status
    • Advance Processing
  • ❺ Dispatching
    • What Is Dispatching?
    • Review Dispatch Items
    • Dispatching Items
    • Compliance
  • ❻ Reporting
    • The Reporting Module
    • AAM Menu
      • Daily
      • Daily Price Level
      • Paragraph 3 by Town
      • Paragraph 3 by Zip
      • Paragraph 3 by Zip/Town
      • Paid and Qualified History
      • History
      • History Price Level
      • Reduced Rates
      • Nth Factor
      • Other Paid Draw
      • Paid Draw by Rate
      • 4% Allowance
      • Subscriber Export
      • Billing Export
      • AAM Draw Export
      • Period Comparison
      • Restate AAM History
      • Digital Access Draw
      • Digital Analysis Report
      • Digital Subscription Audit Report
    • Account Menu
      • Account List
      • Status/Collect Cards
      • Charge/Credit
      • Bond Activity
      • Billed/Unbilled Draw
      • Past Due Letter
      • 1099 Forms
      • 1099 Audit
      • Vacation Pack Labels
      • Drop Credit Audit
    • Audit Menu
      • Transaction Audit Reports
      • Address Audit Reports
      • Occupant Audit Reports
      • Other Audit Reports
      • Setup Audit Reports
    • Churn Reports
    • Management Menu
      • Unearned Revenue
      • GL Interface Journal
      • Audit GL Journal
      • Summary Age Analysis
      • Detail Age Analysis
      • Daily Draw Impact
      • Start/Stop Analysis
      • Retention Analysis
      • Stop Analysis
      • Subscriber Payment Analysis
      • Formal Complaint
      • Complaint Rate
      • Rate by 100
      • District Summary
      • Dispatch Report
      • Address Duplicates
      • Taxable Revenue
      • Draw and Revenue
      • Revenue Comparison Report
      • CC Success Report
    • Market Penetration Reports
    • Postal Menu
      • Financial PO
      • Walk Sequence Cards
    • Route Menu
      • Route Delivery List
      • Route Walk Sequence
      • Complaint
      • Home Deliv Compare
      • Draw Variance
      • Delivery Credit/Draw
      • Draw Analysis
      • Net Draw
      • Pending Messages Report
      • Future Starts Report
      • Router List
    • Single Copy Menu
      • Return Draw Analysis
      • Pilferage
      • Weekly Manifest
      • Single Copy by Day
    • Subscriber Menu
      • Active Mail
      • Active Online
      • Available Refunds
      • Refunds Written Off
      • Refund Cards
      • Grace Due
      • Grace Balance
      • Receivables Aging
      • Writeoff Analysis
      • Grace Written Off
      • End Grace
      • Fee Analysis
      • Fee WriteOff
      • Office Pay Expires
      • Stopped Subscribers
      • Throwoff Subscribers
      • Paid/Unpaid Starts
      • Discount Prediction
      • Subscriber Info Export
      • Balance Forward Bill
      • Undo Balance Forward
      • Subscriber Activity Export
      • Subscriber Activity Import
    • Taxing Menu
      • Tax Exclusion
      • Tax Liability
      • Trans Cost Remit Tax
      • BAS Reconciliation
      • Tax Export
  • ❼ Targeted Marketing
    • Introduction to Targeted Marketing
    • Setup
      • 1. Create a New TM Product
      • 2. Define Selection Criteria for the TM Product
      • 3. Specify the Output Formats for the TM Product
      • Creating New Formats
      • Other Setup Options
    • Processing
    • Undo Processing
    • Selection Summary
    • Copy
    • Campaigns
      • Campaign Setup
      • Canvass Board
      • iServices Campaign Module
      • Business Rules for the iServices Campaign Module
      • Using a Campaign in iServices Subscriber
  • ❽ Tasks
    • Introduction
    • Setup Menu
      • Task Group
      • User Notification
      • Activity Code
      • Task Type
      • Task
      • Alert
    • Tasks Menu
      • My Tasks
      • All Tasks
    • Generating Tasks
    • Tasks in Targeted Marketing and Reports
    • Reports Menu
      • User Statistics Report
      • User Audit Report
    • Utilities Menu
      • Overdue Tasks
  • ❾ Dashboard
    • Introduction
    • Activity by Time
    • Department Activity by Transaction Type
    • User Activity
    • Activity by Source
    • Activity by Reason
    • Activity by Delivery Schedule
    • Complaint Types
    • Task Types
    • Donations
  • ❿ Accounting
    • Introduction
      • Accounting and the General Ledger
      • About Subscriber Rating
      • About Account Rates
      • Subscriber and Account Rating Examples
      • About Payment Authorization
      • About Credit Card Surcharges
      • When to Use Accounting Options
    • Account Billing Menu
      • Selection
      • Processing
      • Billing Journal
      • Invoices
      • Deposit Slips
      • Trans Exclusion
      • Invoice Export
      • Close
      • Invoices on Bundle
      • Missed Invoices
      • Statement Export
      • Undo Processing
      • Billing Run Status
      • Undo Close
      • Interest Calculation
      • Create Bond Charges
      • Create Drop Credits
      • Undo Drop Credits
      • Trial Billing
    • Accruals
    • Account Payments Menu
      • Payment Entry
      • Lockbox Processing
      • Bank Draft Payments
      • Payments to GL
      • Cancel Payment
      • Cancel Credit Payment
      • Payment Journal
      • Cash Batch Audit Journal
      • Apply Unapplied
      • Apply All Unapplied
      • Applied Journal
      • BACS Pre-Notify
      • Proof of Sale Adj
    • Misc. Charge/Credit Menu
      • Miscellaneous Charge
      • Balance Writeoff
      • Cancel Miscellaneous Charge
      • Charges Journal
      • Charge for Complaints
      • Misc. Charges Export
      • Misc. Chg/Cr Import
    • AP/Direct Deposit Menu
      • Interface to AP
      • Midmonth Pmt Export
      • Direct Deposits
      • Credit Journal
      • Vendor Import
      • Vendor Export
      • Vendor Change Report
    • Subscriber Payments Menu
      • Auto Payments
      • Lockbox Processing
      • Batch Payments
        • Business Rules for Subscriber Payments
        • Entering Subscriber Payments
        • How Circulation Determines Term and Length
        • Payments and Discounted Rates
        • Paying for Premium Days
        • Entering Group Payments
        • Generating Rewards
      • Payment Journal
      • Payment Processing
      • Batch Audit Journal
      • Resolve Payments
      • Resolve Journal
      • Pymt Authorization
      • Vindicia Report
      • ACH Status Update
    • Vindicia Payments
    • Subscriber Menu
      • Renewal Notices
      • Undo Renewal Notices
      • Auto Notice Export
      • Send eBills
      • Batch Refunds
      • Refund Journal
      • Refund Writeoff
      • Avail Refund Export
      • Grace Owed Export
      • Grace Writeoff
      • CC Invoice Export
      • Credit Card Expires
      • Trans Cost Export
    • Fiscal Close Menu
      • Close Period (Account)
      • Close Period (Subscriber)
      • Fiscal Close - GL Submenu
        • Export GL
        • Audit GL Transactions
  • ⓫ Utilities
    • Introduction
    • Account Menu
      • Rate Check
      • Draw Export
      • Compare/Update AAM %
      • Update # Households
      • Update Census Tract %
      • Balances
      • Change Recur Charge
      • Holiday Draw
      • Holiday Edition
      • Change Bill Source
      • Change Account ID
      • Rate Change
    • Audience Menu
      • Audience Sync
      • Reset Audience Sync
    • Subscription/Address Menu
      • Batch Addr Hygiene
      • Router Addr Hygiene
      • Change Credit Status
      • Extend Grace Days
      • Dupl Address Edit
      • Dupl Address Report
      • Subscription Purge
      • Address Demographics
      • Product Change Setup
      • Product Change
      • ACS Update
      • Bonus Day Setup
      • Copy Bonus Day Setup
      • Bonus Day Delivery
      • Bonus Day Adjustment
      • Delivery Schedule Change
      • Extend Expire Dates
      • Stop Utility
      • Batch Transactions
      • Sub Length Pricing
      • Auto Accept Batches
    • System Menu
      • Batch Setup
      • Check Disk Space
      • Check Date & Time
      • View/Print
      • Who’s Logged In
      • Process Log Report
      • Purge Process Log
      • Find Fields
      • Purge Session Data
      • Performance Analysis Tools
    • History Purge
    • Setup Menu
      • Bulk Route Changes
      • Bulk Router Updates
      • Truck Validation
      • Route Delivery Sequence
      • Route Delivery Sequence Update
      • Trip Delivery Sequence
      • Trip Delivery Sequence Import
      • Postal Walk Sequence
      • Route Type Change
      • Route ID Change
      • Copy Publ Info
      • GMA/SAM Account Type
      • One Day Rate Change
    • Tools Menu
      • Check Single Copy and Check Home Delivery
      • Move Truck Drop
      • Change Area Code
      • Rerate Subscribers
      • Unlock/Clear Batches
      • Undo Draw Adj Batch
      • Re-Export Interface to AP
      • Re-Export Direct Deposits
      • Re-Export Subscriber Payment Batch
      • Re-Export Direct Debit
      • Find CC Transactions
      • Comboizer
    • Export Menu
      • Subscriber Activity
      • Collectech
      • Subscriber Balances
      • mass2one
      • Rewards
      • Update Cleanse Flag
      • Subscriber Info
      • Draw Impact Export
      • Addresses
      • Subscribe Extract Export
    • Import Menu
      • Billing Change
      • Do Not Call List
      • Subscriber Activity
      • Reward Response
      • Address Information
      • Update Cleanse Flag
      • Communication Hist
      • Auth Import
      • Note Transaction Import
      • Single Copy Demographic Answers
      • Token Account Updater
    • Close Day for AAM
    • Reset End Publ Run
    • Remove End Publ Lock
    • Custom Menu
    • Handheld Export
    • Newsvendor Invoice
    • Weekly Sales Order (WSO) Report
    • Vaulting Service
  • ⓬ Options
    • Introduction
    • Bellatrix Interface
  • ⓭ Appendix A—Glossary
    • A-B
    • C
    • D
    • E-L
    • M-O
    • P-R
    • S
    • T-Z
  • ⓮ Appendix B—File Formats
    • File Formats: An Introduction
    • “Secure” Directory for Private Information
    • 1099 File Format
    • AAM 4% Report Export
    • AAM Billing Export
    • AAM Draw Export
    • AAM Paragraph 3 by ZIP Export
    • AAM Subscriber Export
    • Account Credit Card Payment Formats
    • Account Invoice Scan Line Format
    • ACS Update Format
    • Admail Export File
    • Advance Reconciliation Export Format
    • Audience Sync
    • Auto Notice Export Format
    • Auto Renew Statement Export
    • Available Refund Export
    • Bank Draft Formats
    • Bellatrix Import and Export
    • Bill Format Export Elements (Used for Invoice Export)
    • Bonus Day Adjustment Export Format
    • Bundle Sizes Import Format
    • Burt Address Manager
    • Burt Export Formats
    • Burt Export Formats for TM
    • Cancel Credit Card Payment Format
    • Carrier Collect Invoice Format
    • Chart of Accounts Import
    • Collectech Export Format
    • Desktop Mailer Export
    • District Manager Export
    • Draw Export Format
    • Draw Impact Export
    • Draw Import Format
    • eBill Export Format
    • E-mail Templates
      • General Variables
      • eBill Templates
      • New Password template
      • Digital Vacation Pack template
      • Digital Complaint Template
      • Day Pass Template
      • Start Template
      • Temp Stop - Restart Template
      • Payment Template
      • Tip Donation Template
    • Export/Import Account Rates
    • Export/Import Subscription Rates
    • File Mapping Data Elements
      • 1099 Export
      • 1099 Forms Printing Export
      • Account Lockbox
      • Account Statement Export
      • Address Export and Address Import
      • Alternate Format for Draw Adjustments
      • Alternate Single Copy Draw Change Import
      • Audit GL Transactions
      • Authentication Import
      • Balance Forward Billing Export
      • BAS Reconciliation (Detail)
      • BAS Reconciliation (Summary)
      • Bundle Top Export
      • Campaign Import
      • Carrier Mail Export
      • Cleanse Flag Export
      • Cleanse Flag Import
      • Communication History Import
      • Complaint Export (Detail)
      • Complaint Export (Summary)
      • Credit Card Expires
      • Dispatch Export
      • Do Not Call Import
      • Do Not Call List
      • Draw Adjustments and Returns Import
      • Draw Change Import
      • Draw Forecast Export
      • Drop Credit Audit
      • Drop Time Import
      • GL Audit (Audit GL Journal)
      • GL Export
      • GL Interface Journal
      • Merchandise Report
      • Misc Chg/Credit Import
      • Note Import
      • Office Pay Audit Report
      • Past Due Letter
      • Payment Authorization
      • Postal Billing Export
      • Postal Subscriber Audit
      • Postal Subscriber Full Audit
      • Proof of Sale
      • Renewal Notice
      • Returns Journal
      • Route Data (Route Delivery List Export)
      • Route Labels
      • Router Import
      • Route Smart
      • Single Copy By Day Report
      • Sold Import
      • Stacker Interface
      • Status/Collection Cards
      • Subscriber Activity Export
      • Subscriber Activity Import
      • Subscriber Billing
      • Subscriber Export
      • Subscriber Lockbox
      • Subscriber Payment Journal
      • Subscriber Refund Journal
      • Subscriber Tax Export
      • Subscriber Tran Import
      • Targeted Marketing
      • TM Draw Change Import
      • Token Account Updater
      • Truck Sequence Export
      • Truck Sequence Import
    • General Ledger Interface Format
    • Grace Owed Export
    • Import Vendor Format
    • Insert Base and Draw Export Formats
    • Interface to AP Formats
    • Mail Mart Labels in Targeted Marketing
    • mass2one Export Format
    • Refund Export Formats
    • Refund Writeoff Export
    • Renewal Notice Export Formats
    • Rewards Export Format
    • Rewards Import Format
    • Route Delivery List Export
    • Route Delivery Sequence Update
    • Route ID Change Format
    • Route Type Change Export File
    • Sam Export Formats
    • Single Copy Demographic Import
    • Stacker Interface
    • Subscriber Activity Import Format
    • Subscriber Activity Output Format
    • Subscriber Balances Export Format
    • Subscriber Credit Card Expires Format
    • Subscriber Lockbox File Format (Standard)
    • Subscriber Payment Cancel Export Format
    • Subscriber Payment Formats (Credit Card)
    • Teledirect Formats
    • TM Output File
    • Transportation Cost Export
    • Trip Sequence Import File
    • Truck Manifest Export
    • Vac Pack Label Export
    • Vendor Change Export
    • Vendor Export
Powered by GitBook
LogoLogo

COPYRIGHT © 2024 NAVIGA

On this page
  • Credit Status
  • Office Pay Audit
  • Promotional Payment
  • Subscription Rate
  • Vacation Pack
  • Rate Chains
  • Rate Terms
  • Campaign
  • Credit Card
  • Offsite Audit
Export as PDF
  1. ❻ Reporting
  2. Audit Menu

Other Audit Reports

PreviousOccupant Audit ReportsNextSetup Audit Reports

Last updated 2 years ago

Reports on the Audit-Other menu provide audit trails for various subscriber-related activities, such as subscribers with changed credit statuses or overridden rates. The reports are summarized below.

Credit Status

The Occupant Credit Status Changed report lists occupants whose credit status has been changed within a certain time period, either by an associate or the system. You can run the report to include occupants whose default credit status has changed, occupants whose credit status for a particular product has changed, or both.

Note that the default credit status is the credit status assigned to the occupant when the occupant is added or converted to Circulation; this credit status applies to all products except those for which there is a specific credit status (usually assigned during a new start). If you do not maintain credit status by publication (a Business Rules consideration), the product option will not apply. The fields for this report are described below.

Field
Type
What to enter

OPTION

predefined

Indicate whether the report should include occupants whose default credit status has changed, occupants whose credit status has changed for a particular product, or both.

PRODUCT

setup

If you entered “product” or “both” in the above field, specify the publication for which to list changed credit statuses, or enter “*” to multi-select publications.

START DATE, END DATE

date

Enter the date range for the report. Only credit statuses which have been changed within this date range will be included.

CREDIT STATUS

setup

Enter the credit status for which to run the report, or enter “*” to multi-select credit statuses. Only changes to the credit statuses selected here will be included in the report.

Example—Credit Status Changed Report

Office Pay Audit

Note that Business Rules control the sort order of the Office Pay Subscriber Detail report (account, address, or name). Business Rules also determine whether complimentary subscribers are included in this report. If a subscriber is changed to carrier collect for non-payment and then changed back to office pay when payment is posted, the Office Pay Audit Report does not include the subscriber for the number of days that he/she was carrier collect. However, the carrier receives credit for those days. This back credit appears separately under the Miscellaneous Charges and Credits section of the account’s bill. The report fields are described below.

Field
Type
What to enter

COMPANY

setup

Enter the company to include in the report.

BILL SOURCE

setup

Enter the bill source to include in the report.

START DATE, END DATE

date

Enter the date range to be covered by the report. This refers to the transaction date (not necessarily the entry or processing date).

INCLUDE BACK CREDITS

yes/no

Indicate if the report should include back credits billed during the report period.

INCLUDE FORMER OFFICE PAY

yes/no

Indicate if the report should include subscribers who may have been on the report for a prior period, but no longer qualify to be selected for this run of the report.

TURNOVER CUTOFF

integer(4)

If INCLUDE FORMER OFFICE PAY is selected, indicate how far back the report should look to find office pay subscriptions. The cutoff date is determined by subtracting the value entered in this field from the START DATE. Note: This field is valid only for exports.

REPORT TYPE

predefined

Enter report, export, or both.

FILE FORMAT

setup

Enter a valid file map for Office Pay Audit.

FILE NAME

open

Enter the name of the export file.

FILE FORMAT

predefined

Enter append or replace.

Example—Office Pay Subscriber Detail Report

Promotional Payment

Subscriber rates can be set up as either regular, promotional, or reduced (see Rate Code in the Setup Manual). This report lists all subscribers who have received promotional or reduced rates for a certain publication within a certain date range. The report fields are described below.

Field
Type
What to enter

PRODUCT

setup

Enter the publication you are creating the report for (enter “*” to multi-select publications).

START DATE, END DATE

date

Enter the date range to be covered by the report. The report will only include subscribers that have received reduced or promotional rates within this date range.

RATE TYPE

predefined

Indicate the type of rate (promotional, reduced, or both) to include in the report.

RATE CODE

setup

Enter the rate code to include in the report, or enter “*” to multi-select rate codes.

Example—Promotional Payment Audit Report

Subscription Rate

When entering subscription information, Circulation allows an associate to manually override the rate assigned to the subscriber. The Subscription Rate Audit Report lists the subscribers who have “wrong” rates for a product and date range (for example, a subscriber receives the paper Monday through Saturday but has a Sunday-only rate). The report includes the subscriber’s name, address, delivery schedule, delivery method, and current rate code, and is sorted by subscriber account number.

Vacation Pack

The Vacation Pack Audit Report lists subscribers who have asked for a vac pack during a temporary stop and as a consequence received a discount (some newspapers have vac pack promotions). The report is run for a product and date range.

Example—Vacation Pack Audit Report

Rate Chains

The Rate Chain report lists rate codes that “step up” to a different rate (promotional and reduced rates). The report prompts for a date, and show rate setup as of that day. Each reduced or promotional rate is listed at the left, with subsequent rates displayed to the right. The type of rate will also display in parenthesis, “P” for promotional, “R” for reduced, “N” for normal and “F” for free rate.

For example, if rate A is a 50% off promo that steps up to rate B, a 25% off promo, which steps up to regular rate C, they would display as “A(P) ---> B(P) ---> C(N)”. If a rate incorrectly steps up (for example a reduced or promotional rate that steps up to itself), “ERROR” will be displayed at the end of the rate chain.

Field
Type
What to enter

RUN DATE

date

Enter the date on which the notices will be printed. This field defaults to the current date.

EXPORT

yes/no

Select this checkbox if you want to create an export file.

FILE NAME

open

Enter the name of the file to be exported.

Example—Subscriber Rate Chains report

Rate Terms

The Rate Term report displays the terms and rate amounts for each rate code. The report prompts for a date, and show rate term setup as of that day.

Example—Subscriber Rate Terms report

Campaign

The Campaign report displays the results of a selected campaign for a date range.

Example—Campaign Report

Credit Card

The Credit Card report lists all of the users who have viewed full credit card information, the date and time of the viewing, and the program (menu option) in which it was viewed. Circulation tracks the viewing of unmasked credit card information within the database, even when the credit card information is not changed. For auditing purposes, all views of this private information must be tracked since they could potentially result in the theft of that information. Note: Auditing occurs only for sites that do not store credit card information off-site. When off-site storage is being used, credit card views are not tracked. The fields are described below.

Field
Type
What to enter

ALL USERS USER

yes/no setup

Enter one or more user IDs or select All Users.

ALL CREDIT CARDS CARD NUMBER

yes/no open

Enter a credit card number or select All Credit Cards.

START DATE END DATE

date date

Enter a date range for the report.

EXPORT

yes/no

Indicate if you want to export the information to a file. The data written to the file will be pipe-delimited and have the following format: LogDate | LogTime | UserName | CreditCardNumber | UserProcess | Action | EntityType | Entity

FILE NAME

open

Enter the name of the exported file. Click the lookup icon for a list of tokens that can be used in the file name.

FILE OPTION

predefined

Select Append to write to an existing file of the same name, or Replace to write over an existing file of the same name.

PURGE

yes/no

Select this option to purge the audit data after exporting it. This field is available only if ALL USERS is selected.

Example—Credit Card Audit Report

Offsite Audit

The Offsite Audit report lists discrepancies between transactions stored in the Braintree offsite credit card storage service and Circulation. The report contains two segments:

  • Offsite to Circulation shows discrepancies between the Braintree file and Circulation data.

  • Circulation to Offsite shows transaction data in Circulation and compares it against the data file provided.

A third segment, Processing, lists general errors such as blank or improperly formatted ID numbers.

To use the Offsite Audit report:

  1. Run and download a report from the Braintree merchant gateway. Store the report where it can be accessed from within Circulation.

  2. Select Audit | Other | Offsite Audit to display the Offsite Reconciliation Report window.

  3. Click Add and Enter the name of the Braintree file to be used for the report.

  4. Enter the starting and ending dates of the report. See notes below.

  5. Click OK and then Continue to produce the report.

Notes:

  • This report uses Braintree’s vault date and Circulation’s transaction date, which may not always be the same date. Discrepancies will arise when the vault and transaction dates are different.

  • Credit card numbers are always masked when they appear in the report.

  • This report currently works only with Braintree Offsite credit card storage.

  • Files downloaded from Braintree should be stored in a secure location on your server.

Example—Offsite Reconciliation Report

The Office Pay Subscriber Detail Report is a list, by account and route, of each office pay subscriber. The report can be included with the account’s bill or used for audit purposes. The report and the bill draw on different sources of information; if the two do not match, the bill credit is the correct figure as long as the account’s draw figures are correct. To determine discrepancies between the draw and actual subscribers, print the . You can then enter a draw change to correct the discrepancies.

Draw Variance Exception Report