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

Is there a way to manually enter bank transactions

my account does not have internet acess
10 Comments 10
Teri
Level 9

Is there a way to manually enter bank transactions

Sure.  Accounting existed long before computers on Internet.  Simply do the manual accounting entries.

john-pero
Community Champion

Is there a way to manually enter bank transactions

Yes, of course, and even if your bank did have access it would behoove anyone to learn how to perform manual entry just so you know how and to recognize errors in a connected feed.

 

Upper left of the left hand banner. Add New. Checks for, we checks. Deposits for, you guessed it. You can use Expense instead of a check but you cannot print off a copy of the transaction but you can expense from other than bank (such as owner equity) accounts. 

 

You can also access these tools from the gear icon

vpcontroller
Level 11

Is there a way to manually enter bank transactions

@hpietroforte 

 

"my account does not have internet access"

 

If you've QuickBooks Online, you need internet access to use the browser and log-in to QBO.

Teri
Level 9

Is there a way to manually enter bank transactions

Haha, yes for sure, did not see it was QBO.

Teri
Level 9

Is there a way to manually enter bank transactions

 
Teri
Level 9

Is there a way to manually enter bank transactions

Agree with John, actually best to do entries manually first to learn them before automating bank feed.

Actually is better practice to not have bank feeds, so that you are forced to look at actual accounting.

 

Accounting best practices would never be to input transactions from bank statements or bank feeds. Entries should always be from original source documents (like payroll, invoices, bills, checks, etc).

 

Vendor invoices should be compared to PO's to verify price and quantity or services and rates agreed.

Confirming shipping and taxes and payment terms and authorization/approval of amounts to be paid.

 

Good internal controls are for bank statement reconciliation to be done after all entries are posted to confirm amounts expected are what hit bank statement. Ideally reconciled by another person. 

 

However, users have been doing this for decades so many people have never done any other way and everyone prefers electronic convenience over accuracy or verification to confirm not overcharged. 

 

Explanation attached for anyone who moves to a larger company where you won't see bank statements.

hpietroforte
Level 1

Is there a way to manually enter bank transactions

This is an attorney client trust account and the bank does not permit online access to the bank account. Therefore, we cannot link the bank account to quick books online. We only get paper statements. The only way that quick books is allowing us to add an account is to connect the bank account online but we cannot do that since we cannot view this account with online banking.

john-pero
Community Champion

Is there a way to manually enter bank transactions

Not true. Yes from the banking tab but go to the Cart of Accounts on the left and add a new account. The only subscriptions that cannot add a manual bank account is the Self-Employed version

RenjolynC
QuickBooks Team

Is there a way to manually enter bank transactions

I'd like to help you with your banking concern, hpietroforte.

 

You'll want to manually enter the transactions in Excel, make sure to use either a 3-column or 4-column format. Then, save it as a CSV file and import it into QuickBooks Online.

 

Here's how:

 

  1. Go to Banking on the left panel.
  2. Select the File Upload button.
  3. Click the Browse button and choose the CSV file.
  4. Select or add the bank account where you want to post the bank transactions.
  5. Click Next and map the fields. 
  6. Select Next and then Let's go!.

You can open this article for the detailed instructions: Import bank transactions using Excel CSV files.

 

Please let me know if you need anything else. I'll be around to help you some more. Take care and stay safe.

Teri
Level 9

Is there a way to manually enter bank transactions

So your original post here said you did not have internet access but clearly you do if you get this message, unless you are on a different device.


@hpietroforte wrote:
my account does not have internet acess

As noted below, without Internet, you could not even access QBO at all. So assume you can do that.

 

So what you are really saying is that you cannot connect QBO to your bank for some reason, right?

 

So where are you stuck now?

 

 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us