Immediately after you've selected the text file to import, GnuCash will bring up the Import Preview window. Select File / Import / Import transactions from CSV. Unfortunately, your Test Data files in your example are NOT well-formatted, but I'll come back to that. The Import Transactions process can be a bit fiddly to set up, but once you've got it set up correctly GnuCash does a pretty good job of importing well-formatted data. Destination accounts are processed as expected but all source transactions end up in the Imbalance account rather than the intended source Asset/liability account.Ĭheque Account Date,Amount,No,Ledger:Account-Category,Description,MemoĠ1-03-06,"1,000.00",Equity:Opening Balance,Opening Balance,Starting BalanceĠ5-03-06,-45.21,101,Expenses:Groceries,Grocery Shop,Grocery StoreĠ5-03-06,-75.00,105,Expenses:Groceries,HomeTown Grocery,HomeTown GroceryĠ6-03-06,100.00,Transfere Money,TransferĠ6-03-06,100.00,106,Expenses:Split,ABC Hardware,ABC Hardwareġ4-03-06,1000.00,Expenses:Split,Employers R Us,SalaryĢ4-03-06,500.00,Transfer Money,TransferĢ5-03-06,-100.00,ATM Withdrawal,ATMĢ8-03-06,-20.00,Expenses:Internet,Internet Subscription,Best InternetĢ8-03-06,-78.00,102,Expenses:Electricity,Light Company,Light CompanyĢ8-03-06,-45.00,103,Expenses:Phone,Phone Company,Phone CompanyĢ8-03-06,-350.00,104,Expenses:Rent,April Rent,Apartment 4 Rentģ1-03-06,-5.00,Expenses:Service Charge,Service Charge,Service ChargeĢ8-04-06,-350.00,Expenses:Rent,May Rent,Apartment 4 RentĠ5-05-06,-300.00,Partial Payment of Visa Bill,To Account 123833255.Haven't managed to configure the Transaction Import Assistant date format as dd/mm/yy like the Win10 Regional format data settings so currently restricted to d-m-y for csv import.Is there a GnuCash quickstart tutorial to cover this? Expecting to load the statements and the transactions would show in the source bank account and the target income/expenditure account. Confused about setting up GnuCash file using the Transaction Import Assistant to load Bank Statements.
0 kommentar(er)
