Skip to navigation Skip to content
EzyLearn Pty Ltd
  • Home
  • Courses
  • Learning Tools
    • Learning Tools
    • Training Manuals
    • Training Library
  • Training Options
    • Training Options
    • Short Course Enrolment
    • Enrolment with Funding
    • Retraining
  • Blog
    • Blog
    • Subscribe
  • Contact
  • Login
  • Home
  • Courses
  • Learning Tools
    • Learning Tools
    • Training Manuals
    • Training Library
  • Training Options
    • Training Options
    • Short Course Enrolment
    • Enrolment with Funding
    • Retraining
  • Blog
    • Blog
    • Subscribe
  • Contact
  • Login
  • $0.00 0 items
Home / Posts tagged “Reconciling bank accounts for start ups”

Tag: Reconciling bank accounts for start ups

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, 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
Blog Search
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

Subscribe for news, updates, tips and tricks

Enter your email address:

Delivered by FeedBurner

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
  • Where will you look to find your next job?
  • Is Xero the software of choice for real estate property managers
  • Xero will win the struggle against QuickBooks. Here’s how.
  • How my 7 year old son learnt about credit risk and how that can help tradies
  • Creating the Xero & MYOB Course Training Workbooks
  • Online Business Courses FREE with Xero, MYOB, Excel
  • Is Xero Certification Valuable for Job Seekers or Contract Bookkeepers?
  • UPDATE: Xero, MYOB and QuickBooks Training Course Content
  • ATTN: Ongoing Course Access for $39 per year
  • Office Academy gives Microsoft skills to all staff, online, remotely – October $200 OFF
  • Sorry Apple, but MYOB is opting out of AccountEdge because of Catalina
  • APOLOGIES to students on behalf of MYOB Essentials Accounting Software
  • Customer Service: Important Skills for Data Entry, Office Support and Accounts Jobs
  • How do you feel about learning something new?
  • Discount Coupon Code: Bookkeeping Academy – MYOB & Xero & QuickBooks & Reckon
  • Xero Accounting to Excel Spreadsheets to MailChimp & Email Marketing
  • Xero & QuickBooks Slug it out on Receipt Scanning Features
  • Learning Xero Will Help You Run An Online Business
  • Buying an Online Business: What is it worth?
  • Data Entry and Microsoft Office Skills: Important for NSW Police Call Centre Work and Virtual Assistants
  • Remote Working? Remote Learning? What Will You Get Done This Week?
  • Is Remote Working From Home Going To Become The New Normal?
  • ALERT: Reckon One Training Course PRE-Launch SPECIAL
  • ALERT: QuickBooks Online Training Courses Updated
  • Lowest MYOB Training Course Price Guarantee
  • It’s wise to include Sage One in Bookkeeping Academy (pst.. free samples available)
  • EzyLearn students can upgrade to ongoing or LIFETIME course access
  • Airtasker Desparately Seeking Links
  • It’s official. Digital marketing now part of office administration job description
  • One reason why businesses are migrating away from MYOB
  • Migrating Away from MYOB AccountRight to Xero or QuickBooks
  • Earn a % of Xero & MYOB course enrolments as an EzyLearn Affiliate
  • Someone just got the sack because they didn’t know the bookkeeping basics
  • Payroll & staff underpayments affect you even if Xero, QBO or MYOB say it’s easy
  • EzyLearn Students Earn Money with our Online Courses
  • Bank Feeds: Time Saver but NOT a Bookkeeper Replacer – FREE Training Course Material
  • Xero going up a pesky $2 rather than $27.50
  • Learn Microsoft Excel Beginners to Advanced for $1
  • STRONG LANGUAGE WARNING: I hate Telstra Online Essentials
  • Behind in your ATO Payroll requirements for STP (Single Touch Payroll)
  • Inventory and Stock is more beautiful using QuickBooks than Xero
  • Learn Payroll Administration in 1 day for $99 – Limited Time Course Offer
  • Are your love languages stopping you from studying MYOB & Xero before Xmas?
  • Announcement: Microsoft Excel Training Workbooks Instant Download
  • Design and produce business documents & data entry using Microsoft Word
  • The Perfect Xero Training Motivation for Tradies
  • Sage One Training Course Workbook – Launch Price
  • Terms of Trade and Credit Risk Controllers
  • Announcement: MYOB, Xero and QuickBooks Training Manuals now available for sale
  • Master the data entry job skills. Get some free training too
Recent Posts
  • Where will you look to find your next job?
  • Is Xero the software of choice for real estate property managers
  • Xero will win the struggle against QuickBooks. Here’s how.
  • How my 7 year old son learnt about credit risk and how that can help tradies
  • Creating the Xero & MYOB Course Training Workbooks
  • Online Business Courses FREE with Xero, MYOB, Excel
  • Is Xero Certification Valuable for Job Seekers or Contract Bookkeepers?
  • UPDATE: Xero, MYOB and QuickBooks Training Course Content
© EzyLearn Pty Ltd 2021
Built with Storefront & WooCommerce.
  • My Account
  • Search
  • Cart 0
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: