cancel
Showing results for 
Search instead for 
Did you mean: 
AdrianM2
Level 1

Import Expense split by class

Hello all

So to explain, every week I am charged by one Vendor for fuel, our company uses. QBO pulls the transaction from our bank feed. Every time before I categorize the transaction, I usually split it in 3 different account, fuel paid, fuel fees, fuel discount received.

This is fine but not ideal, the ideal would be to also split "fuel paid", for each vehicle (each vehicle has its own class), the same with "fuel discount received". This was we can see exactly how much we paid in fuel for each vehicle.

I also receive a statement from the fuel card provider, a csv file, that shows each vehicle how much fuel used.

I tried to make this file work with batch import but with no luck.

When you chose to import bacth transactions, and chose expenses, everything is straight forward, online, but the sample file they provide is for importing services, not expenses, or in my case its just one expense but split in different accounts and classes.

1 Comment 1
Fiat Lux - ASIA
Level 15

Import Expense split by class

You can prepare your expense data as Bills, CC Charges, or Purchase-cash and split one transactions into classes if required. Then utilize an importer tool

https://transactionpro.grsm.io/qbo

 

Need to get in touch?

Contact us