B+,
Here is my Script BASIC console mode version.
' QBO Account Table Listing
OPEN "acct_all.txt" FOR INPUT AS 1
qboxml = INPUT(LOF(1),1)
SPLITA qboxml BY "</Account>" TO accts
FOR x = 0 TO UBOUND(accts)
IF accts[x] LIKE "*<Id>*</Id>*<Name>*</Name>*<AccountType>*</AccountType>*<CurrentBalance>*</CurrentBalance>*" THEN
PRINT joker(2),STRING(7-LEN(joker(2))," ")
PRINT joker(4),STRING(40-LEN(joker(4))," ")
PRINT joker(6),STRING(25-LEN(joker(6))," ")
PRINT FORMAT("%~###,###.00-~",joker(8)),"\n"
END IF
NEXT
jrs@jrs-laptop:~/work/Finch/sb/test$ time scriba qbo_acct.sb
33 Accounts Payable (A/P) Accounts Payable 1,602.67-
84 Accounts Receivable (A/R) Accounts Receivable 5,281.52
7 Advertising Expense 0.00
89 Arizona Dept. of Revenue Payable Other Current Liability 0.00
55 Automobile Expense 0.00
56 Fuel Expense 0.00
8 Bank Charges Expense 0.00
85 Billable Expense Income Income 0.00
90 Board of Equalization Payable Other Current Liability 370.94-
35 Checking Bank 1,201.00
9 Commissions & fees Expense 0.00
80 Cost of Goods Sold Cost of Goods Sold 0.00
40 Depreciation Other Expense 0.00
82 Design income Income 0.00
86 Discounts given Income 0.00
28 Disposal Fees Expense 0.00
10 Dues & Subscriptions Expense 0.00
29 Equipment Rental Expense 0.00
5 Fees Billed Income 0.00
11 Insurance Expense 0.00
57 Workers Compensation Expense 0.00
25 Interest Earned Other Income 0.00
81 Inventory Asset Other Current Asset 596.25
58 Job Expenses Expense 0.00
59 Cost of Labor Expense 0.00
60 Installation Expense 0.00
61 Maintenance and Repairs Expense 0.00
62 Equipment Rental Expense 0.00
63 Job Materials Expense 0.00
64 Decks and Patios Expense 0.00
65 Fountain and Garden Lighting Expense 0.00
66 Plants and Soil Expense 0.00
67 Sprinklers and Drip Systems Expense 0.00
68 Permits Expense 0.00
45 Landscaping Services Income 0.00
46 Job Materials Income 0.00
47 Decks and Patios Income 0.00
48 Fountains and Garden Lighting Income 0.00
49 Plants and Soil Income 0.00
50 Sprinklers and Drip Systems Income 0.00
51 Labor Income 0.00
52 Installation Income 0.00
53 Maintenance and Repair Income 0.00
12 Legal & Professional Fees Expense 0.00
69 Accounting Expense 0.00
70 Bookkeeper Expense 0.00
71 Lawyer Expense 0.00
43 Loan Payable Other Current Liability 4,000.00-
72 Maintenance and Repair Expense 0.00
73 Building Repairs Expense 0.00
74 Computer Repairs Expense 0.00
75 Equipment Repairs Expense 0.00
41 Mastercard Credit Card 157.72-
13 Meals and Entertainment Expense 0.00
14 Miscellaneous Other Expense 0.00
91 MyClients Accounts Receivable 0.00
44 Notes Payable Long Term Liability 25,000.00-
15 Office Expenses Expense 0.00
34 Opening Balance Equity Equity 9,337.50
83 Other Income Income 0.00
26 Other Portfolio Income Other Income 0.00
27 Penalties & Settlements Other Expense 0.00
54 Pest Control Services Income 0.00
3 Prepaid Expenses Other Current Asset 0.00
16 Promotional Expense 0.00
78 Purchases Expense 0.00
6 Refunds-Allowances Income 0.00
17 Rent or Lease Expense 0.00
2 Retained Earnings Equity 0.00
79 Sales of Product Income Income 0.00
36 Savings Bank 800.00
1 Services Income 0.00
19 Stationery & Printing Expense 0.00
20 Supplies Expense 0.00
21 Taxes & Licenses Expense 0.00
22 Travel Expense 0.00
23 Travel Meals Expense 0.00
37 Truck Fixed Asset 0.00
39 Depreciation Fixed Asset 0.00
38 Original Cost Fixed Asset 13,495.00
88 Unapplied Cash Bill Payment Expense Expense 0.00
87 Unapplied Cash Payment Income Income 0.00
32 Uncategorized Asset Other Current Asset 0.00
31 Uncategorized Expense Expense 0.00
30 Uncategorized Income Income 0.00
4 Undeposited Funds Other Current Asset 2,062.52
24 Utilities Expense 0.00
76 Gas and Electric Expense 0.00
77 Telephone Expense 0.00
42 Visa Credit Card 0.00
real 0m0.022s
user 0m0.020s
sys 0m0.000s
jrs@jrs-laptop:~/work/Finch/sb/test$
