Question

Can a CSV file be imported into QBO?

Forum|Forum|4 years ago
December 21, 2021
1 reply
0 views

can I or my new payroll co, import a CSV file into QBO?

QuickBooks Online

Fiat Lux - ASIA

Prepare your payroll data as Journal Entry with the following template

RefNumber	TxnDate	PrivateNote	IsAdjustment	Currency	ExchangeRate	Account	LineAmount	LineDesc	Entity	Class	Location
101	01/10/2020	Wire Transfer	FALSE			Savings	-50.00	Credit Savings
101	01/10/2020	Wire Transfer	FALSE			Checking	50.00	Debit Checking
102	01/10/2020	Wire Transfer	FALSE			Savings	200.00	Debit Savings
102	01/10/2020	Wire Transfer	FALSE			Checking	-200.00	Credit Checking

then utilize an importer tool

https://transactionpro.grsm.io/qbo