- 1 Introduction
- 2 Customers
- 2.1 Adding customers
- 2.2 Searching for customers
- 2.3 Customer view
- 2.3.1 Actions
- 2.3.2 Comments / Notes
- 2.3.3 Tickets
- 2.3.4 Packages
- 2.3.5 Payment history and actions
- 3 Ticketing
- 4 Searching and Reporting
- 4.1 Customers
- 4.2 Invoices
- 4.3 Packages
- 4.4 Services
- 4.5 Usage
- 4.6 Tickets
- 4.7 Financial Reports
- 5 Tools
- 6 Auditing Legacy Data
AGPL now, and MySQL is also supported
Customers, Packages and Services
http://www.freeside.biz/~ivan/freeside-slides/html/slide_4.html (simple case: single package and service)
Searching for customers
View customer's referrals
Comments / Notes
Payment history and actions
Invoices are generated by the system. The charges on each invoice reflect the setup/one-time, recurring and usage charges of that customer's packages. Invoices increase the customer's balance.
To add new packages or charges to a customer, use the "Order new package" or "One-time charge" links in the Packages section of the Customer View page.
To generate a pending invoice for a customer, use the "Bill now" link at the top of the Customer View page.
Payments are money the customer pays. Payments decrease the customer's balance.
Check and Cash payments
- To post a check or cash payment, use the "Enter check payment" or "Enter cash payment" links at the top of the Payment History section of the customer view page.
- Enter the amount of the payment.
- For check payments, enter the check number.
- Leave "Auto-apply to invoices" set to "yes" if you would like the system to apply the payment to any open invoices (oldest first). Or change "Auto-apply to invoices" to "no" if you would like to apply the payment to invoice(s) (or refund(s)) manually.
- Multiple check payments can also be entered in a batch under Tools -> Quick Payment Entry.
Credit card and electronic check (ACH) payments
- Credit card or electronic check payments will be initiated by the system for customers with Billing Type "Credit card (automatic)" or "Electronic Check (automatic)".
- Payments can be initiated manually by using the "Process credit card payment" or "Process electronic check (ACH) payment" links, in the Payment History section of the customer view page.
- Enter the amount to process (defaults to the customer's current outstanding balance).
- For credit card payments, enter the card number, expiration date, name on card and billing address. If the customer has a card on-file, the masked card number ("4111xxxxxxxx1111") and other information can be left as-is to charge the on-file card.
- For electronic check payments, enter the account number, account type, ABA or routing number, and bank name (other information such as bank state, social security number, or driver's license number may also be required by some payment gateways). If the customer has electronic checking information on-file, the masked account number and other information can be left as-is to charge the on-file bank account.
- Check "Remember this information" to save the payment information on-file.
- Also check "Charge future payments to this credit card/electronic check automatically" to charge the customer automatically in the future.
- Customers may use the self-service interface to pay by credit card or electronic check themselves.
- Payments are applied to a specific invoice (or split between multiple invoices).
- The "(apply)" and "(unapply)" links next to specific payment (in the Payment History section of the customer view page) can be used to change the application of payments to specific invoice(s) and/or refunds(s).
Credits are adjustments to the amount the customer owes. Credits decrease the customer's balance.
- To post a credit, use the "Enter credit" link at the top of the Payment History section of the customer view page.
- Enter the amount to credit.
- Select the reason for the credit or enter a new reason.
- Leave "Auto-apply to invoices" set to "yes" if you would like the system to apply the credit to any open invoices (oldest first). Or change "Auto-apply to invoices" to "no" if you would like to apply the credit to invoice(s) (or refund(s)) manually.
- Like payments, credits can be applied to an invoice (or split between multiple invoices). For example, a credit to reverse an incorrect invoice or write off an invoice as bad debt could be applied to that specific invoice.
- Credits can also be applied to refunds to indicate that the credit was refunded to the customer instead.
- The "(apply)" and "(unapply)" links next to specific credits (in the Payment History section of the customer view page) can be used to change the application of credits to specific invoice(s) and/or refunds(s).
Refunds are money paid to the customer. Refunds increase the customer's balance.
Check and Cash refunds
- Posting refunds
- Applying and unapplying refunds.
Credit card and electronic check (ACH) refunds
- To refund a specific credit card or electronic check (ACH) payment back to the customer, use the "(refund)" link next to that specific payment (in the Payment History section of the customer view page). This will process a refund for the amount of the payment with the payment gateway.
Link to RT documentation
Searching and Reporting
- To search for a customer, enter the customer number, name, company name or contact phone number into the "Search customers" box at the top of each page. Name and company are "fuzzy" searches that will attempt to find a close match if no exact match is found.
- Other customer browsing and reporting is available from Reports -> Customers
- For advanced reporting with specific criteria, use the "Advanced" link next to the "Search customers" box at the top of each page, or go to Reports -> Customers -> Advanced customer reports
- To search for a customer by invoice number or service information (such as username, email address, domain or service phone number), use the invoice or service search, then click on the customer or "View this customer" link.
- To search for an invoice, enter the invoice number into the "Search customers" box at the top of each page.
- Other invoice browsing and reporting is available from Reports -> Invoices
- For advanced reporting with specific criteria, use the "Advanced" link next to the "Search invoice" box at the top of each page, or go to Reports -> Invoices -> Advanced invoice reports
- Package browsing and reporting is available from Reports -> Packages
- For advanced reporting with specific criteria, go to Reports -> Packages -> Advanced package reports
FCC Form 477
- visit Configuration->Settings and set cust_main-require_censustract to Yes
- visit Configuration->Packages->Package report classes and add classes to match the FCCs reporting requirements
- edit your package definitions (Configuration->Packages->Package definitions) to include some report classes
- visit Reports->Customers->Advanced customer reports to find customers lacking census tract information
- edit customers who lack census information - you should either see a popup asking for census information or it will be automatically filled when you save the customer
- visit Reports->Packages->Advanced package reports to generate reports which may filter by ALL selected "report classes" (logically ANDed)
- visit Reports->Packages->FCC Form 477 packages to generate reports collated by census tract
Once logged into the fcc system, one can offer it one or more files for upload via its html forms. For 'small' systems (fewer than 5000 broadband subscriptions) we support a single file upload. The size restriction is an FCC restriction on the number of lines in the XML file.
To prepare the report for upload, one must first tag package definitions with appropriate report classes. 'Appropriate' depends on context. For example, if a reporting entity must submit FCC Part IIA then the reporting entity must designate which packages contain 'unswitched UNE loops' and must tag the definitions with a report option which means this. If Part IIA is to be submitted, then each package definition must have the 'voice grade equivalency' for each package (defalt is 0). The global config cust_pkg-show_fcc_voice_grade_equivalent must be enabled to edit this.
Once the packages are tagged, useful reports may be generated. By visiting Reports->Packages->FCC Form 477 you may choose which 'parts' of the FCC form to generate (since not all parts are meaningful to all companies). In Part IA all download speeds and all upload speeds must be set meaningfully and at least one technology must be set. Part IB is not presently supported. Parts IIA and IIB depend on the ds0 equivalency number. They make use of the report options to calculate the percentage of the whole number of ds0s. All of parts I and II rely on the existance of a company name in the customer record for determining if the package is residential or not. Part III is not supported at this time. Part IV offers free form comments. Parts V and VI depend on parts II and I respectively. Only selection of their generation may be selected (and is ignored if the antecedents are missing).
After pressing the submit button, the top 'XML file' link represents a file suitable for uploading to the FCC as an XML file as long as fewer than 5000 broadband connections are being reported. Parts V and VI may also be downloaded as CSV files from links adjacent to the section. This (particularly VI) should be useful for larger entities who must perform the upload in parts.
- To search for a service such as username, email address, IP address, MAC address, domain or service phone number, enter the search data into the "Search servcies" box at the top of each page.
- Other service browsing and reporting is available from Reports -> Services
- To search for a ticket, enter the ticket number, subject, or email address into the "Search tickets" box at the top of each page.
- A fulltext ticket search can also be performed by entering "fulltext:searchstring" where searchstring is the string to search for.
- For advanced reporting with specific criteria, use the "Advanced" link next to the "Search tickets" box at the top of each page.
Sales, Credits and Receipts
Payment Batch Report
Go to Reports -> Financial -> A/R aging to pull up an aging report
- Select "All customers" to pull up a report including all customers.
- Select "Customers with a balance" (the default) to pull up a report only including customers with a balance. Optionally enter a number of days to pull up a report only including customers with balances over the specified number of days old.
Sales tax liability
Go to Reports -> Financial -> Sales tax liability to pull up a report of total sales and taxes, for example, to pull up numbers to add to Quickbooks or another accounting package.
- Enter start and end dates to restrict the search to a specific time period.
- Check "Show tax classes" to break down sales and taxes by tax class.
- Check "Show package classes" to break down sales and taxes by package class.
- In the resulting sales tax report, all clickable links take you to a detail report of the specific items making up the number reported.