Exporting Data >
Open kBilling® and the company file you would like to use.
From the File menu on the main window's menu bar choose Export -> Export Customers.
The format of the export file is 1 record per line with tab characters between the fields.
Each record is on a single line with 1 tab character between the following fields in the order shown:
|1.||Customer Number [Unique or blank] |
|6.||Billing State [Abbreviation for US and Canada]|
|13.||Ship State [Abbreviation for US and Canada]|
|16.||Credit Card Number [16 Digits - Numbers Only]|
|17.||Credit Card Expiration Month [2 Digits]|
|18.||Credit Card Expiration Year [4 Digits]|
|22.||Primary Contact Phone Number [Any Format]|
|23.||Secondary Contact Phone [Any Format]|
|24.||Contact Fax [Any Format]|
Excel and most other spreadsheet programs can open TSV (tab separated file) formatted files!