Fiat Lux - ASIA
Level 15

Banking

@13rent 

As far as I know, importing *.qbo files is one of the features of online banking even if you do it manually. If you are using an outdated version of QBD, you will no longer be able to use the feature. You can only import them from CSV/XLS format by using a 3rd party importer tool as I mentioned before. You will prepare data with certain format like this one

 

Bank Statement

Bank AccountTransaction DatePayeeChk No.AccountAmountMemoClassBillableBillable Entity
Checking01/09/2020AT&T123Utilities:Telephone-100Check Payment N 
Checking02/09/2020Jane Doe141Product Sales150Deposit N 

 

Credit Card Stetement

Credit Card AccountTransaction DatePayeeRefNumberAccountAmountMemoClassBillableBillable Entity
QuickBooks Credit Card01/10/2020Hampton Inn1234Travel:Lodging150  YJohn Doe
QuickBooks Credit Card12/10/2020Staples123465Office Supplies-15Return N