{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Account Chart","Transactions","Income Statement"],"read":"whole","date_system":"1900"}

{"sheet":"Account Chart","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
["Account Type","Account Name"]
["Income","Sales"]
["Expense","Office Supplies"]
["Expense","Utilities"]
["Expense","Advertising"]
["Expense","Bank Charges"]
["Expense","Rent"]
["Expense","Transportation"]
["Expense","Meals & Entertainment"]
["Expense","Software Subscriptions"]

{"sheet":"Transactions","index":1,"n_rows":15,"n_cols":6,"rows_kept":15}
["Date","Invoice/Receipt No.","Customer/Vendor","Amount (USD)","Account","Description"]
["2025-10-01","INV-001","Client A",{"v":1200,"d":"$1,200.00"},"Sales","Website design project"]
["2025-10-02","EXP-001","Office Depot",{"v":200,"d":"$200.00"},"Office Supplies","Purchased printer ink and paper"]
["2025-10-03","EXP-002","PowerCo",{"v":150,"d":"$150.00"},"Utilities","Electricity bill payment"]
["2025-10-04","INV-002","Client B",{"v":900,"d":"$900.00"},"Sales","Consulting income"]
["2025-10-05","EXP-003","Meta Ads",{"v":500,"d":"$500.00"},"Advertising","Facebook ad campaign"]
["2025-10-06","INV-003","Online Store",{"v":2000,"d":"$2,000.00"},"Sales","E-commerce order revenue"]
["2025-10-07","EXP-004","Bank of America",{"v":100,"d":"$100.00"},"Bank Charges","Monthly bank service fees"]
["2025-10-08","EXP-005","RentCo",{"v":300,"d":"$300.00"},"Rent","Office rent payment"]
["2025-10-09","INV-004","Client C",{"v":1000,"d":"$1,000.00"},"Sales","Mobile app development"]
["2025-10-10","EXP-006","FuelMart",{"v":250,"d":"$250.00"},"Transportation","Delivery vehicle fuel"]
["2025-10-11","EXP-007","Bistro 21",{"v":120,"d":"$120.00"},"Meals & Entertainment","Client lunch meeting"]
["2025-10-12","EXP-008","NetConnect",{"v":80,"d":"$80.00"},"Utilities","Internet bill"]
["2025-10-13","INV-005","Client D",{"v":600,"d":"$600.00"},"Sales","Maintenance contract income"]
["2025-10-14","EXP-009","SoftPro",{"v":400,"d":"$400.00"},"Software Subscriptions","Accounting software renewal"]

{"sheet":"Income Statement","index":2,"n_rows":17,"n_cols":2,"rows_kept":17}
["Category","Amount (USD)"]
["Revenue"]
[{"$f":"'Account Chart'!B2","v":"Sales"},{"$f":"SUMIF(Transactions!E:E,\"Sales\",Transactions!D:D)","v":{"v":5700,"d":"$5,700.00"}}]
["Total Income",{"$f":"B3","v":{"v":5700,"d":"$5,700.00"}}]
[]
["Expenses"]
[{"$f":"_xlfn._xlws.FILTER('Account Chart'!B:B, 'Account Chart'!A:A=\"Expense\")","v":"Office Supplies"},{"$f":"SUMIF(Transactions!E:E,A7,Transactions!D:D)","v":{"v":200,"d":"$200.00"}}]
["Utilities",{"$f":"SUMIF(Transactions!E:E,A8,Transactions!D:D)","v":{"v":230,"d":"$230.00"}}]
["Advertising",{"$f":"SUMIF(Transactions!E:E,A9,Transactions!D:D)","v":{"v":500,"d":"$500.00"}}]
["Bank Charges",{"$f":"SUMIF(Transactions!E:E,A10,Transactions!D:D)","v":{"v":100,"d":"$100.00"}}]
["Rent",{"$f":"SUMIF(Transactions!E:E,A11,Transactions!D:D)","v":{"v":300,"d":"$300.00"}}]
["Transportation",{"$f":"SUMIF(Transactions!E:E,A12,Transactions!D:D)","v":{"v":250,"d":"$250.00"}}]
["Meals & Entertainment",{"$f":"SUMIF(Transactions!E:E,A13,Transactions!D:D)","v":{"v":120,"d":"$120.00"}}]
["Software Subscriptions",{"$f":"SUMIF(Transactions!E:E,A14,Transactions!D:D)","v":{"v":400,"d":"$400.00"}}]
["Total Expenses",{"$f":"SUM(B7:B14)","v":{"v":2100,"d":"$2,100.00"}}]
[]
["Net Profit/Loss",{"$f":"B4-B15","v":{"v":3600,"d":"$3,600.00"}}]