Skip to navigation Skip to content
EzyLearn Pty Ltd
  • Training Options
  • Learning Tools
  • Career Academy
  • Workbooks
  • Tutorials
  • Blog
  • Contact
  • Home
  • Career Academy
  • Contact
  • Login
  • Blog
  • $0.00 0 items
Home / Posts tagged “bank reconciliation process”

Tag: bank reconciliation process

Posted on June 15, 2017June 14, 2017 by Steve Slisar

Bank Reconciliation Process for Start Ups

Don’t miss a thing with an Excel expense sheet

xero myob cheap online learning training course videos
The simple act of creating an Excel spreadsheet to itemise your expenses can help you keep track of everything eating into your business’ cashflow – even if not strictly deductible.

HAVE YOU RECENTLY STARTED running your own business? Whether you have, or whether you’re about to, reconciling your bank accounts regularly is probably one of the best ways to monitor your expenditure in relation to your income.

If you’re operating your start up venture as a sole trader, the best way to keep tabs of where your expenditure sits is to use a cloud accounting application like Xero, MYOB or QuickBooks — in addition to a Microsoft Excel spending or expense sheet.

Your accounting software will help you to keep track of your income and business expenses and other important things that will affect your start up — such as how long it takes to get paid — while an Excel spending or expense sheet will help you to monitor all of your spending, business or otherwise.

The bank reconciliation process

This starts when you get your bank statement, but you can speed the process up, by entering recurring expenses into your Excel spreadsheet as they occur.

Remember that not all of your expenses are 100 percent business ones so you’ll need to estimate what percentage of your internet usage, for instance, has been for business purposes.

In your Excel spending sheet, you’ll enter the expense in total, but in your accounting software, you’ll only enter the percentage of the expense that relates to your business.

Identify cash flow problems

If your business has poor cash flow, using an Excel spending sheet in addition to your accounting software will allow you to identify what’s causing your cash flow problems. Sometimes cash flow problems are caused by later payers, due to poor credit management processes. Other times, however, you may find that you’re simply not earning enough to cover your expenses each week or month.

To remedy this immediately, you should look through your Excel spending sheet and see if there are any expenses, either business or discretionary ones, that you can reduce or eliminate. Then you should work on increasing your income. That’s easier said than done, which is why you should reduce your spending first.

Forecasting profit

If you don’t identify any cash flow issues, you will be able to begin forecasting profit. Typically, profit just refers to the income left over after all your business expenses have been accounted for.

But there are plenty of start ups and sole traders, who have a profitable business but are not profitable themselves.

That’s because there are many other expenses in your ordinary life — the remaining 70 percent of your internet bill, for example — that you still need to pay for.

If you’re also recording all your other expenses in an Excel spending sheet, you’ll be able to forecast your business’s profit, as well as your own personal profit (otherwise known as savings) with much greater accuracy.

The chart of accounts

In effect, what you’re doing here is creating a chart of accounts. You’ll learn more about the chart of accounts in our Xero and MYOB courses, but they are, in a nutshell, a financial record of every account — asset, liability, equity, revenue, etc — in your business.

***

You can learn how to create and manage your expenses or spending in our Excel training courses, where you’ll be able to create your own spending or expense sheet, and how to perform daily bank reconciliations in MYOB or Xero in our cloud accounting training courses. For more information, visit our website.


learn xero myob excel cheap online training courses videos

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses (and earn CPD points!) to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (Excel, PowerPoint, Word) or social media and WordPress web design). Many of our courses are provided with ALL LEVELS included for ONE LOW PRICE.


 

Share this:

  • Email
  • Facebook
  • LinkedIn
  • Twitter
  • Pinterest

Like this:

Like Loading...
Categories: Bookkeeper and bookkeeping business, Bookkeeping Courses, Cloud Accounting, Computer Software Training, Continuing Professional Development (CPD) for Bookkeepers, Good Bookkeeper, Microsoft Excel Training Course, MYOB Online Training Course, MYOB Training Courses, Online Excel Training, Services, Small Business, Small Business Finance Training Courses, Small Business Productivity, Training Courses, xero training, Xero Training Courses
Tags: bank reconciliation process, bookkeeping business, cloud accounting, Excel expense sheet, Excel spending sheet, Microsoft Excel, microsoft excel course, MYOB Bookkeeper, MYOB courses, myob online course, MYOB training courses, online training, Reconciling bank accounts for start ups, reconciling business account, Xero daily reconciliations, xero training, xero training courses

Search this site

Type the first 3 characters to discover courses, up-skilling programs and CPD articles.

EXTEND your 12 months to LIFETIME course access

EzyLearn-Career-Courses-in-Data-Entry-Office-Support-Credit-Management-and-Office-Admin-Jobs-square

Enrolled into an EzyLearn course since 2013?

Get access to new & updated course content and support by joining the EzyLearn Career Courses Program.

See how to extend your course life & support

Employer Recognised & Trusted Online Training Courses

Employer Recognised and Trusted Online Excel, Word, Office, MYOB, Xero, QuickBooks Online Training Courses

Popular Online Courses

Facebook social media marketing and advertising course logo

 

 

Real Estate Agent, Bookkeeper & Accountant CPD Courses

EzyLearn Online Course CPD points for bookkeepers and marketing professionals

Use our informative and logical

  1. training courses,
  2. micro courses, and
  3. case studies

to learn how to use software relating to your industry in small, well designed learning experiences and get the CPD points you need to remain professionally compliant with your industry association.

Learn more

Why Choose EzyLearn
  • - Save money
  • - One cost for LIFETIME membership
  • - One cost for all levels in each course
  • - Videos, Workbooks and Knowledge Reviews
  • - Accredited MYOB, Xero Courses
  • - Money Back Guarantee
Recent Posts
  • If ANZ Bank Buys MYOB will you EVER need to reconcile again?
  • NEW Bookkeeping Basics $49 Online Course Covers Beginner Level Skills using Xero, MYOB & QuickBooks Online
  • The Best Xero Course in Australia
  • Square Afterpay or PayPal Pay in 4: Which BNPL Service Your Business Should Use
  • Planday for Xero or Square Team Management: Which Should Your Business Use?
  • Payroll Training Course Integrations: Square Payroll versus Xero?
  • STP Phase 2 Training Added to Xero Payroll Course – Learn ALL Payroll Courses Across Multiple Software in Advanced Certificate in Payroll Administration
  • Are You Complying With Your Fringe Benefits Tax Liability of up to 47% (especially COVID-19 related ones)?
  • Why is Xero Saying Your PayPal Bank Connection Needs Updating?
  • Here’s What Businesses Need to Know About eInvoicing in Xero
  • Intuit (QuickBooks) Buys Mailchimp! – Marketing Will Finally Speak to Accounts.
  • Xero Asks Nicely for Feedback using NPS, But EzyLearn Interviewed Xero Course Students via Zoom
  • Engaging a New Worker? Here Are The Things You Need To Do, particularly if you’re classified by the ATO as a withholder:
  • Xero’s Integration With DiviPay Can Help Small Businesses Manage Expenses
  • Could This Free Social Media Promotion Work For Your Bookkeeping or Virtual Assistant Business?
  • CommBank and Xero Integration to Help Small Businesses Get Paid Faster
  • Xero Announces New Product Features – EzyLearn Offers 12 months Course Access and Support!
  • ATO’s SUPER GUARANTEE CHARGE Could Slug Employers Extra for Late Super Payments (SG vs SGC)?
  • How are Small Businesses Changing in 2022?
  • How Microsoft Word and Excel Training Can Improve Your Work Life
  • Pandemic Digitalised Small Businesses more than NBN, Xero Report Reveals Numbers?
  • MYOB Business is AccountRight & Essentials but can it catch up to Xero?
  • Our Students Have Been Talking – Here’s What They Have to Say
  • NEW Advanced Certificate In Payroll Administration Includes ALL Payroll Courses Across Multiple Software
  • Office Administration or Business Administration: What Jobseekers Need To Know
  • Here’s How to Find the Best Training Course for You
  • Why is Xero’s Share Price Plummeting?
  • Xero My Payroll App Training Now Included in Xero Payroll Administration Course
  • ALERT: MYOB Essentials Shock New Credit Card Requirement to Trial is Unexpected and Unwanted
  • Get Paid for Talking About Your Work Life
  • Xero Expands in Canada with 4000 Tax Firms in TaxCycle Acquisition
  • Will This Xero Integration Replace Your Accounting Job or Just Lessen the Load?
  • Looking For Bookkeeping Work? This is How You Can Stand Out To Employers
  • ATO Announces Changes to Single Touch Payroll & EzyLearn has New STP Phase 2 Training Materials
  • Get Paid Faster By Using Clear Terms of Trade
  • Here’s What You Need to Know About the Cash Conversion Cycle
  • Tired of Chasing Unpaid Invoices? Here’s Which Credit Management Apps Can Help
  • Will Jim’s Pay Plans Cause an Aftershock for Afterpay?
  • Sales Tax Simplified With Xero’s TaxJar Integration
  • 16 Apps to Customise Hubspot But Xero Gets the Worst Rating
  • Finally, Xero Acquires an Inventory Management Software Add-on in the US
  • Integrations turn Xero into a Powerful Business Administration System for Small Business
  • Digital Business Skills to Compliment Xero & MYOB Training
  • Xero Me – the App That Prepares Xero Users for Planday Acquisition
  • Xero Verify or Google Authenticator?
  • Telstra is pimping MYOB Essentials with 3 months FREE. MYOB is pimping a page out of George Orwell’s 1984
  • This is Why Businesses Love Cloud Accounting and not MYOB AccountRight so much
  • Attn: New Advanced Excel Certificate Course topics
  • NEW: MYOB In Tray and Receipt Capture training course materials for MYOB Essentials
  • Want FREE accounting software? Tell QuickBooks you’re going to become a contract bookkeeper

Blog Categories

  • 123ezy Websites for People
  • Accounting Tutors
  • Accounts Payable
  • Accounts Receivable
  • Accounts Receivable
  • Accredited Training
  • Advanced Certificate in Office Administration
  • Affiliate Marketing
  • Announcements
  • Application Tracking Systems
  • Bank Reconciliation
  • Become a real estate agent
  • Blogging for Business
  • Bookkeeper and bookkeeping business
  • Bookkeeping & Accounts Jobs
  • Bookkeeping Academy
  • Bookkeeping Business Induction
  • Bookkeeping Business Marketing
  • Bookkeeping Courses
  • Bookkeeping for Beginners
  • Bookkeeping Skills
  • Business Administration
  • Buy an online business
  • Career Academy
  • Career Academy
  • Career Support
  • Cashflow Training Courses
  • Casual Accounting Jobs
  • Cert IV in Bookkeeping & Accounting
  • Clients
  • Cloud Accounting
  • Cloud Computing
  • Communications
  • Computer Software Training
  • Content Marketing
  • Continuing Professional Development (CPD) for Bookkeepers
  • Corporate Training
  • Credit Management
  • Credit Management
  • Customer Service Jobs
  • Customer Service Training Course
  • Data Entry
  • Digital Marketing Courses
  • Digital Marketing Courses
  • Drop Shipping
  • Employment
  • Expense Management
  • Facebook Advertising Course
  • Financial Reporting
  • Find a good bookkeeper
  • Find Work and get a Job
  • FREE MYOB Training Course
  • Good Bookkeeper
  • Google Analytics Training Courses
  • Google Training Course
  • Government
  • Induction
  • Integrations
  • Introduction to Bookkeeping
  • Inventory & stocktake
  • Job Applications
  • Job Boards
  • Job Getter
  • Job Hunter
  • Job Seekers
  • MailChimp Course
  • Microsoft Excel Training Course
  • Microsoft Excel training course
  • Microsoft Word Courses
  • Microsoft Word Training Course
  • Microsoft Word Training Courses
  • Migrating
  • MYOB Essentials Training Courses
  • MYOB Online Training Course
  • MYOB training course
  • MYOB Training Courses
  • National Bookkeeping
  • New South Wales (NSW)
  • News
  • Office Admin Jobs
  • Office Administrator
  • Office Support Jobs
  • One-on-one
  • one-to-one training
  • Online Excel Training
  • Online Induction
  • Online MYOB Training Business
  • Online PowerPoint Training Course
  • Part time Accounts Jobs
  • Payroll Administration
  • Payroll Course
  • Payroll Officer
  • Point of Sale (POS)
  • Powerpoint Online Training Courses
  • Property Investment
  • Quickbooks Courses
  • QuickBooks Online
  • Real Estate Agents
  • Real Estate Course
  • Receipt Scanning
  • Reckon One
  • Resume Writing
  • Roster & Timesheets
  • Sage One Training Courses
  • Scheduling & Rosters
  • Selling Academy
  • Services
  • Side Hustle
  • Single Touch Payroll
  • Site Induction
  • Small Business
  • Small Business Finance Training Courses
  • Small Business Marketing Training Courses
  • Small Business Operations Training Courses
  • Small Business Partnership Agreement Course
  • Small Business Productivity
  • Small Business Sales Training Courses
  • Small Business Start Up Course
  • Small Business StartUp Course
  • Social media
  • Social Media and Digital Marketing Course
  • Start a business
  • Student Support
  • Temporary Accounting Jobs
  • Training Courses
  • Uncategorized
  • Updates
  • Victoria (VIC)
  • Website and Internet Marketing
  • Website Design
  • Word Online Training Course
  • WordPress Training Course
  • WordPress Training Courses
  • Work from home
  • Work Remotely
  • Xero Advanced Certificate Course
  • Xero Projects & MYOB Job Tracking
  • xero training
  • Xero Training Courses
  • Xero Training Courses Updates
Recent Posts
  • If ANZ Bank Buys MYOB will you EVER need to reconcile again?
  • NEW Bookkeeping Basics $49 Online Course Covers Beginner Level Skills using Xero, MYOB & QuickBooks Online
  • The Best Xero Course in Australia
  • Square Afterpay or PayPal Pay in 4: Which BNPL Service Your Business Should Use
  • Planday for Xero or Square Team Management: Which Should Your Business Use?
  • Payroll Training Course Integrations: Square Payroll versus Xero?
  • STP Phase 2 Training Added to Xero Payroll Course – Learn ALL Payroll Courses Across Multiple Software in Advanced Certificate in Payroll Administration
  • Are You Complying With Your Fringe Benefits Tax Liability of up to 47% (especially COVID-19 related ones)?
© EzyLearn Pty Ltd 2022
Built with Storefront & WooCommerce.
  • My Account
  • Search
  • Cart 0
%d bloggers like this: