Expense Category Import Problem
I tried importing into an Asset Account a "Capital" Expense category transaction and it made an Income category.
The category is listed as "Capital:50Exp" but it couldn't find 'Capital'.
Here are the transactions,
Capital:50Exp,5/28/2019,Transfer to Assets,,49208.8
Capital:50Exp,6/6/2019,Transfer to Assets,,1137
I tried importing this into a Bank Account and the same thing happened.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by agabhart36 on 03 Mar, 2026 07:30 PM
The problem is directly related to which column the import Amount is. If it's positive it makes it into an Income Category as in here
Capital:4742Exp,12/4/2019,Transfer to Assets,,14391.66
RepMaint:4742Exp,12/1/2020,Transfer to Capital,,675
Capital:4742Exp,12/1/2020,Transfer to Capital,,-2960.5
Capital:4742Exp,12/1/2020,Transfer to Capital,,-675
Capital:4742Exp,12/1/2020,Transfer to Capital,,-43.78
Capital:4742Exp,12/1/2020,Transfer to Assets,,3679.28
Supplies:4742Exp,12/1/2020,Transfer to Capital,,43.78
Also the 2 NOT Capital entries were changed into Capital entries
What should have happened is it should have Created 2 new sub-Categories, instead it appropriated Capital.
All of these were converted to Comms or commissions
Capital:14530 ScrippsExp,11/21/2019,Transfer to Assets,,102740.11
Capital:14530 ScrippsExp,1/21/2020,Transfer to Capital,,1570.4
TaxLics:14530 ScrippsExp,1/21/2020,Transfer to Capital,,-1570.4
Capital:14530 ScrippsExp,8/1/2020,Transfer to Capital,,-800
Comms:14530 ScrippsExp,8/1/2020,Transfer to Capital,,800
Capital:14530 ScrippsExp,8/12/2020,Transfer to Capital,,253
Capital:14530 ScrippsExp,1/22/2021,Transfer to Capital,,5122.44
Update @7:15pm. It seems it goes for the 2nd half of the denoted category.
So, if it's TaxLics:14530 ScrippsExp, it will show up as Capital:14530 ScrippsExp.
Also, On a 2nd similar entry, the category suggester does pick up on the TaxLics and presents similar suggestions.