- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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:
- Import bank transactions using Excel CSV files.
- Manually upload transactions into QuickBooks Online.
- Format CSV files in Excel to get bank transactions into QuickBooks.
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content