cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
DKP2
Level 1

CAPTURE BANK STATEMENTS MANUALLY

Hi Please advise how do I capture my bank statements manually without connecting to my bank or using the csv / txt upload file option. thank you

5 Comments 5
AileneA
QuickBooks Team

CAPTURE BANK STATEMENTS MANUALLY

Hello, DKP2. 

 

You can download your bank statement directly from your financial institution. Just log in to your bank website, from there you can import it to excel. 

 

Here are some helpful references that you can check out about using the online banking feature, as well as importing bank data manually in QuickBooks: 

 

 

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

DKP2
Level 1

CAPTURE BANK STATEMENTS MANUALLY

Thank you for your response.

 

Is there no way to do it manually without importing or uploading?  I do not want to import or upload, I want to do it manually. 

 

Kind regards

AlexV
QuickBooks Team

CAPTURE BANK STATEMENTS MANUALLY

Let me share more details about bank transactions, DKP2.

 

The easiest and most convenient way to bring in and categorise your bank transactions is to link your bank or upload a file. However, you still have an option to manually record them.

 

You can record the sales transactions using either invoice or sales receipt. The bills, cheques, and expenses are for expenses or money out transactions.

 

Please note that you still need a copy of your bank statement when you reconcile your accounts. You'll use it to compare the actual versus the entries in QuickBooks Online so they'll be in balance.

 

Leave a comment again if you need anything else. Have a great day!

DKP2
Level 1

CAPTURE BANK STATEMENTS MANUALLY

Thank you for your reply.

 

Where would I capture expenses not related to suppliers or customers?  It does not give me the option to choose a expense type.

 

My problem is, TRY AS I MIGHT, I can not upload my bank statements it keeps on giving an error.

Error - Transaction date, memo and amount not found..... I did put it in my excel CVS file, followed each and every step you suggested but no luck. And I am fed-up spending time on this. I need to get the transactions in to reconcile.

 

 

Fiat Lux - ASIA
Level 15

CAPTURE BANK STATEMENTS MANUALLY

@DKP2 

Explore the trial license of this converter app as a workaround.

https://www.moneythumb.com/?ref=110