I've updated the guide data for testing purposes: updated year to 26 and added some transaction notes and split memo.
Generalised Process Used to Create Book File 1. Create empty file: * Open GnuCash and choose File > New File. * When the "New Account Hierarchy Setup" configuration window appears, click Cancel to skip the built-in system selectors. * Choose File > Save As to establish a path identity for your blank database profile (eg gnc-guide.gnucash). 2. Populate Account Tree: * Choose File > Import > Import Accounts from CSV.... * Select the gnc_guide_accounts.csv file. * Check Number of rows for header is 1 and the file delimiter option is set to Comma. Ensure all data columns are mapped to their corresponding account fields. * Click Apply and finalise to check that the accounts imported successfully. 3. Import and Parse Multi-Split Transactions: * Choose File > Import > Import Transactions from CSV.... * Select the transaction matrix file gnc_guide_example.csv. * CRITICAL: Look inside the configuration window options area and explicitly check the Multi-split checkbox option, set the Date format as d-m-y, and set Leading lines to skip to 1. * Map your file import columns to their corresponding target data labels in the preview grid, panning the window horizontally to the right if required to access all fields. * GnuCash will prompt you to run a text-matching verification pass to map string references to your new account names. Review the screens and confirm the import. Regards
Type,Full Account Name,Account Name,Account Code,Description,Account Colour,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder ASSET,Assets,Assets,,Asset Accounts,,,AUD,CURRENCY,F,F,F ASSET,Assets:Current Assets,Current Assets,,Current Assets,,,AUD,CURRENCY,F,F,F CASH,Assets:Current Assets:Cash in Wallet,Cash in Wallet,,Cash in Wallet,,,AUD,CURRENCY,F,F,F LIABILITY,Liabilities,Liabilities,,Liability Accounts,,,AUD,CURRENCY,F,F,F LIABILITY,Liabilities:Credit Card,Credit Card,,Credit Cards,,,AUD,CURRENCY,F,F,F CREDIT,Liabilities:Credit Card:Visa,Visa,,Visa Credit Card,,,AUD,CURRENCY,F,F,F INCOME,Income,Income,,Income Accounts,,,AUD,CURRENCY,F,F,F INCOME,Income:Salary,Salary,,Salary Income,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses,Expenses,,Expense Accounts,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Car,Car,,Car,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Clothes,Clothes,,Clothing Expenses,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Electricity,Electricity,,Electricity Utility,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Food,Food,,Food,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Groceries,Groceries,,Grocery Shopping,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Household,Household,,Household Expenses,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Interest,Interest,,Credit Card Interest Expense,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Internet,Internet,,Internet Subscription,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Phone,Phone,,Phone Utility,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Rent,Rent,,House Rent,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Service Charges,Service Charges,,Bank Service Charges,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Taxes,Taxes,,Tax Payments,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Taxes:Federal,Federal,,Federal Income Tax,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Taxes:Income Tax,Income Tax,,Income Tax,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Taxes:Medicare,Medicare,,Medicare Tax,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Taxes:Social Security,Social Security,,Social Security Tax,,,AUD,CURRENCY,F,F,F EXPENSE,Expenses:Tools,Tools,,Hardware Tools,,,AUD,CURRENCY,F,F,F EQUITY,Equity,Equity,,Equity Accounts,,,AUD,CURRENCY,F,F,F EQUITY,Equity:Opening Balance,Opening Balance,,Opening Balance,,,AUD,CURRENCY,F,F,F BANK,Bank,Bank,,,,,AUD,CURRENCY,F,F,F BANK,Bank:Checking,Checking,,Checking,,,AUD,CURRENCY,F,F,F BANK,Bank:Savings,Savings,,Savings,,,AUD,CURRENCY,F,F,F
Date,Number,Description,Notes,Memo,Account,Amount 25/03/26,,ATM Withdrawal,,,Assets:Current Assets:Cash in Wallet,100 ,,,,,Bank:Checking,-100 01/03/26,,Opening Balance Checking,,,Bank:Checking,1000 ,,,,,Equity:Opening Balance,-1000 05/03/26,,Partial Payment,,,Liabilities:Credit Card:Visa,300 ,,,,,Bank:Checking,-300 05/03/26,101,Grocery Store,,,Expenses:Groceries,45.21 ,,,,,Bank:Checking,-45.21 05/03/26,105,Hometown Grocery,,,Expenses:Groceries,75 ,,,,,Bank:Checking,-75 06/03/26,,Transfer Money,,,Bank:Checking,100 ,,,,,Bank:Savings,-100 06/03/26,106,ABC Hardware,,#tax,Expenses:Household,50 ,,,,,Expenses:Tools,50 ,,,,,Bank:Checking,-100 15/03/26,,Employers R Us,,,Bank:Checking,670 ,,,,,Expenses:Taxes:Federal,180 ,,,,,Expenses:Taxes:Medicare,90 ,,,,,Expenses:Taxes:Social Security,60 ,,,,tax,Income:Salary,-1000 24/03/26,,Transfer Money,,,Bank:Checking,500 ,,,,,Bank:Savings,-500 28/03/26,,Internet Subscription,#tax #house test,,Expenses:Internet,20 ,,,,,Bank:Checking,-20 28/03/26,102,Light Company,,,Expenses:Electricity,78 ,,,,,Bank:Checking,-78 28/03/26,103,Phone Company,#tax,,Expenses:Phone,45 ,,,,,Bank:Checking,-45 28/03/26,104,April Rent,#house,,Expenses:Rent,350 ,,,,,Bank:Checking,-350 31/03/26,,Service Charge,,,Expenses:Service Charges,5 ,,,,,Bank:Checking,-5 28/04/26,,May Rent,#house,,Expenses:Rent,350 ,,,,,Bank:Checking,-350 05/05/26,,Partial Payment of Visa Bill,,,Liabilities:Credit Card:Visa,300 ,,,,,Bank:Checking,-300 01/03/26,,Opening Balance Savings,,,Bank:Savings,1000 ,,,,,Equity:Opening Balance,-1000 01/03/26,,Opening Balance,,,Equity:Opening Balance,500 ,,,,,Liabilities:Credit Card:Visa,-500 12/04/26,,Premium Gasolin,,,Expenses:Car,25 ,,,,,Liabilities:Credit Card:Visa,-25 03/04/26,,Jeans R Us,,,Expenses:Clothes,74.99 ,,,,,Liabilities:Credit Card:Visa,-74.99 ,,,,,Liabilities:Credit Card:Visa,74.99 ,,,,,Expenses:Clothes,-74.99 11/04/26,,Faux Pas Fashions,,,Expenses:Clothes,100 ,,,,,Liabilities:Credit Card:Visa,-100 ,,,,,Liabilities:Credit Card:Visa,100 ,,,,,Expenses:Clothes,-100 07/04/26,,Greasy Spoon Cafe,,,Expenses:Food,25 ,,,,,Liabilities:Credit Card:Visa,-25 14/04/26,,Groceries R Us,,,Expenses:Groceries,85 ,,,,,Expenses:Household,40 ,,,,,Liabilities:Credit Card:Visa,-125 15/04/26,,CheapMart,,,Expenses:Household,60 ,,,,,Liabilities:Credit Card:Visa,-60 30/04/26,,Interest,,,Expenses:Interest,20 ,,,,,Liabilities:Credit Card:Visa,-20
gnc-guide.gnucash
Description: application/gnucash
_______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
