top of page

Bank Statements and Reconciliations

Good morning. I would just like to share a few details regarding bank reconciliations. I'm seeing on several occasions that people are confused about the requirements, especially between bus agent, bookkeeper versus accountant. There's a bit of a mixed perception as to what is required. So technically the best practice is to pass your bank statement to the bookkeeper or accountant at the end of every month.


They then reconcile the balance in your software, whether it's Xero or MYOB, at the end of the month, to the balance on your bank statement. If your bank statement's saying that you have 1, 000 in the account, then your software should say 1, 000. What we're looking for is that it's true and fair and, transparent.


If the balance is not 1, 000, it's effectively saying that there is a problem. So that's where we then investigate whether there is a duplicate. You may have entered a invoice in or a bill in twice. You might have entered it as a bill, and then in when the bank feeds came in, you might have, entered it as a spend money.


So effectively the bill could be closed to the bank account. The spend money could then be allocated again. So then it's there twice, meaning your balance will be over. Also, there could be bank feeds that just happen to not have come in or a duplicate bank feed. It could also be that someone whether it's the owner of the file or an employee of the file has gone in and imported, bank statements or bank transaction lines into your software account.


So that looks like, Maybe you've started a new credit card. Sometimes when you start that balance, you are asked whether you would like to import from a certain date, like start your transactions to import to the software on a certain date. Sometimes you may have to start at that date. It might take two weeks, but it might start on the day that you applied for your bank feeds.


to connect with your software, which means you may need to import the difference from the beginning of whenever that account started. So that account, effectively, you might need to bring in 10 days worth of transactions or a month or whatever. Sometimes that could cause a duplicate because you may bring in more and it might double over from when the file actually started if you're not sure where to look.


to see what's imported versus, the automatic feeds coming in from your bank. So, again, that is another reason why. Also, there may be things that actually aren't reconciled. So it might say they're saying unreconciled. It, you need to push that through. So, basically, it's saying you need to enter a sale and allocate the payment to the sale that's been received, or you may need to enter the bill.


So, And then apply the payment to the bill. So it also can show overpayments and underpayments. So you are very clear of what your income actually is. And if there's an overpayment, you can enter that part as a received money and then show it waiting as a credit balance, or apply the whole to the actual invoice and show it as a credit.


And then, you know, that's clearly money as accounts receivable, waiting to be refunded to the client. So you basically want to make sure that the balance matches because when you go to process the BAS or the bookkeeper, the accountant goes to process the BAS, your, You're clearly aware of what your true expenses and income are, especially if there is duplicates in there because you don't want to be paying extra tax twice on several items if you've only actually paid for it once.


That's why it's quite important to show the correct balance. The other important part of this too is, you can clearly show or prove that at every point. Every like at the end of every month that that account actually reconciled to your bank statement at the time, because sometimes the bank, the software gets unlocked and people accidentally put data in at the wrong date.


So they might actually be entering a bill today, but instead of saying that it was paid today's date, they might accidentally, if they're not paying attention and distracted, they might accidentally close, put the payment date as. Well, the 13th of May 2023, which If you're on a cash basis, the payment will then be shown back last year and not now.


So then your BAS, when you go to lodge it, the beginning balance or the balance from previously lodged will have changed, and it won't be accounted for now. You might actually close that bill down in the future. You might actually accidentally put, 13th of September, 2024.


You could put the next year, 2025. It could be future dated, which means that account won't reconcile. And what happens is that it shows there is unreconciled, you would like. You're clearly looking for, for two clear lines, the software balance and your imported or your bank feed balance should be identical and it should be nil difference.


If there's, if, if you see the screen and it says that there is unreconciled, it's showing that there's, it doesn't balance. So therefore your data is not correct and your, not reporting true figures to the ATO. So sometimes you hear of accountants saying, we don't need to see your bank statements. We just push through what the transactions are in your bank feeds.


Now that's not really the best practice. I don't agree with it. I can see where they're coming from, but basically what they're saying is you are signing an agreement. You're giving them the authority to lodge their BAS based on the fact that you as the director or the owner of the business are being true and fair, are being transparent, have supplied all your invoices and, entered all the sales in and that you have provided bank statements, and that your accounts are reconciled.


So basically, yes, you can look at the accountants or your bookkeepers, but usually I find it's the accountants who, if they're saying we don't need to see it. And then you move on to another bookkeeper and they're like, where's our statements? We'd like to have the statements and you're pushing back saying, well, the previous accountant or bookkeeper didn't ask for them.


They just worked on whatever the figures were in the feeds. It's not the correct practice and it, it, needs to be addressed moving forward because at the end of the day, it's actually you as the owner or director of the business. It's your responsibility and you need to be read the documents that you're signing Because the ATO are going to say, but you've signed this authorizing that person to lodge your BAS Stating that you are being true and fair and correct and that you have done the correct process so it's actually your responsibility and that's how they push back and so that's why I'm trying to address that you need to step up and, and recognize where your responsibility lies as opposed to, as opposed to pointing to your agent or your accountant and saying it's their responsibility.


Cause yes, it, it is their responsibility as well, but at the end of the day, the buck stops with you.




 
 
 

Comments


CONTACT
LOCATION
OPENING HOURS

Email: corina@starbyder.com.au
Mobile: 0417 161 301

 

PO Box 258

Narangba,

QLD 4504

Mon - Fri: 9am - 5pm

​​Saturday: Closed

​Sunday: Closed

 Burpengary, Deception Bay, Rothwell, Strathpine, Albany Creek, Bracken Ridge, Dayboro, Samford, Kings Scrub, Kingaroy, Bribie Island, Woodford, Herston, Eagle Farm, Whiteside, Landsborough, Donnybrook, North Brisbane, Kedron, Sandgate, Clontarf, Petrie, Everton Park, Samford Valley, Samford Village, Camp Mountain, Wamuran, Delaneys Creek, D'Aguilar, Glass House Mountain, Beerwah,Glen View, Melany, North Melany, Moffit Beach, Golden Beach, Caloundra, Pelican Waters, Sippy Downs, Buderim, Mooloolaba, Nambour, Ningi, Ocean View, Ningi, 
Bookkeeper, Bookkeeper Northside, Bookkeeper North Brisbane, Bookkeeping Northside, Bookkeeping North Brisbane, Payroll Northside, Payroll North Brisbane, Payroll, BAS Northside, BAS North Brisbane, Geebung, Wavell Heights, Stafford Heights, Chermside, Virginia, Northgate, Aspley, Kedron, Stafford, Gordon Park, Nundah, Grange, Alderley, Enoggera, Ashgrove, Paddington, Fortitude Valley, Bulimba, Bowen Hills, Hamilton, Ascot, Toombul, Toowong, Indooroopilly,  Mitchelton, Ferny Hills, Nundah, Upper Kedron, The Gap, Gumdale, Thornlands, Wakerley, Hemmant, Pinkenba, Lytton, Clayfield, Eagle Farm, Murarrie, Zillmere, Taigum, Deagon, Bracken Ridge, Carseldine, Nudgee Kenmore, Chapel Hill, St Lucia, Yeronga, Marooka, Brookfield, BAS Agent, Accountnt, Accounting, reconcile accounts, help Books, XERO, MYOB, Hubdoc, Dext, Tradies, Satisfied Customers in: Bowen Hills, Brisbane City, East Brisbane, Fortitude Valley, Herston, Highgate Hill, Kangaroo Point, Kelvin Grove, New Farm, Newstead, Paddington, Petrie Terrace, Red Hill, South Brisbane, Spring Hill, Teneriffe, West End, Woolloongabba, Albion, Alderley, Ascot, Aspley, Bald Hills, Banyo, Boondall, Bracken Ridge, Bridgeman Downs, Brighton, Brisbane Airport, Carseldine, Chermside, Chermside West, Clayfield, Deagon, Eagle Farm, Everton Park, Ferny Grove, Fitzgibbon, Gaythorne, Geebung, Gordon Park, Grange, Hamilton, Hendra, Kalinga, Kedron, Keperra, Lutwyche, McDowall, Mitchelton, Myrtletown, Newmarket, Northgate, Nudgee, Nudgee Beach, Nundah, Pinkenba, Sandgate, Shorncliffe, Stafford, Stafford Heights, Taigum, Virginia, Wavell Heights, Wilston, Windsor, Wooloowin, Zillmere, Acacia Ridge, Algester, Annerley, Archerfield, Burbank, Calamvale, Coopers Plains, Darra, Doolandella, Drewvale, Durack, Dutton Park, Eight Mile Plains, Ellen Grove, Fairfield, Forest Lake, Greenslopes, Heathwood, Holland Park, Holland Park West, Inala, Karawatha, Kuraby, Larapinta, MacGregor, Mackenzie, Mansfield, Moorooka, Mount Gravatt, Mount Gravatt East, Nathan, Pallara, Parkinson, Richlands, Robertson, Rochedale, Rocklea, Runcorn, Salisbury, Seventeen Mile Rocks, Sinnamon Park, Stones Corner, Stretton, Sumner, Sunnybank, Sunnybank Hills, Tarragindi, Tennyson, Upper Mount Gravatt, Wacol, Willawong, Wishart, Yeerongpilly, Yeronga, Balmoral, Belmont, Bulimba, Camp Hill, Cannon Hill, Carina, Carina Heights, Carindale, Chandler, Coorparoo, Gumdale, Hawthorne, Hemmant, Lota, Lytton, Manly, Manly West, Moreton Island, Morningside, Murarrie, Norman Park, Port of Brisbane, Ransome, Seven Hills, Tingalpa, Wakerley, Wynnum, Wynnum West, Anstead, Ashgrove, Auchenflower, Bardon, Bellbowrie, Brookfield, Chapel Hill, Chelmer, Chuwar, Corinda, Enoggera, Enoggera Reservoir, Fig Tree Pocket, Graceville, Indooroopilly, Jamboree Heights, Jindalee, Karana Downs, Kenmore, Kenmore Hills, Kholo, Lake Manchester, Middle Park, Milton, Moggill, Mount Coot-tha, Mount Crosby, Mount Ommaney, Oxley, Pinjarra Hills, Pullenvale, Riverhills, Seventeen Mile Rocks, Sherwood, Sinnamon Park, St Lucia, Taringa, The Gap, Toowong, Upper Brookfield, Upper Kedron, Westlake, Augustine Heights, Barellan Point, Basin Pocket, Bellbird Park, Blacksoil, Blackstone, Booval, Brassall, Brookwater, Bundamba, Camira, Carole Park, Churchill, Chuwar, Coalfalls, Collingwood Park, Dinmore, East Ipswich, Eastern Heights, Ebbw Vale, Flinders View, Gailes, Goodna, Ipswich, Karalee, Karrabin, Leichhardt, Moores Pocket, Muirlea, New Chum, Newtown, North Booval, North Ipswich, North Tivoli, One Mile, Raceview, Redbank, Redbank Plains, Riverview, Sadliers Crossing, Silkstone, Springfield, Springfield Central, Springfield Lakes, Tivoli, West Ipswich, Woodend, Wulkuraka, Yamanto, Amberley, Ashwell, Calvert, Deebing Heights, Ebenezer, Goolman, Grandchester, Haigslea, Ironbark, Jeebropilly, Lanefield, Marburg, Mount Forbes, Mount Marrow, Mutdapilly, Pine Mountain, Purga, Ripley, Rosewood, South Ripley, Spring Mountain, Swanbank, Tallegalla, Thagoona, The Bluff, Walloon, White Rock, Willowbank, Woolshed, Bahrs Scrub, Bannockburn, Beenleigh, Belivah, Berrinba, Bethania, Boronia Heights, Browns Plains, Buccan, Carbrook, Cedar Creek, Cedar Grove, Cedar Vale, Chambers Flat, Cornubia, Crestmead, Daisy Hill, Eagleby, Edens Landing, Forestdale, Greenbank, Heritage Park, Hillcrest, Holmview, Jimboomba, Kagaru, Kingston, Logan Central, Logan Reserve, Logan Village, Loganholme, Loganlea, Lyons, Marsden, Meadowbrook, Mount Warren Park, Mundoolun, Munruben, New Beith, North Maclean, Park Ridge South, Park Ridge, Priestdale, Regents Park, Rochedale South, Shailer Park, Slacks Creek, South Maclean, Springwood, Stockleigh, Tamborine, Tanah Merah, Underwood, Undullah, Veresdale Scrub, Veresdale, Waterford West, Waterford, Windaroo, Wolffdene, Woodhill, Woodridge, Yarrabilba, Alexandra Hills, Amity Point, Birkdale, Capalaba, Cleveland, Coochiemudlo Island, Dunwich, Karragarra Island, Lamb Island, Macleay Island, Mount Cotton, North Stradbroke Island, Ormiston, Point Lookout, Redland Bay, Russell Island, Sheldon, Thorneside, Thornlands, Victoria Point, Wellington Point, Albany Creek, Arana Hills, Banksia Beach, Beachmere, Bellara, Bongaree, Bray Park, Brendale, Bunya, Burpengary, Caboolture, Caboolture South, Cashmere, Clontarf, Dakabin, Deception Bay, Eatons Hill, Elimbah, Everton Hills, Ferny Hills, Godwin Beach, Griffin, Joyner, Kallangur, Kippa-Ring, Kurwongbah, Lawnton, Mango Hill, Margate, Moodlu, Morayfield, Murrumba Downs, Narangba, Newport, Ningi, North Lakes, Petrie, Redcliffe, Rothwell, Sandstone Point, Scarborough, Strathpine, Upper Caboolture, Warner, Whiteside, Woody Point, Woorim, Armstrong Creek, Bellmere, Bellthorpe, Booroobin, Bracalba, Camp Mountain, Campbells Pocket, Cedar Creek, Cedarton, Clear Mountain, Closeburn, Commissioners Flat, D'Aguilar, Dayboro, Delaneys Creek, Donnybrook, Draper, Highvale, Jollys Lookout, King Scrub, Kobble Creek, Laceys Creek, Meldale, Moorina, Mount Delaney, Mount Glorious, Mount Mee, Mount Nebo, Mount Pleasant, Mount Samson, Neurum, Ocean View, Rocksberg, Rush Creek, Samford Valley, Samford Village, Samsonvale, Stanmore, Stony Creek, Toorbul, Wamuran Basin, Wamuran, Welsby, White Patch, Wights Mountain, Woodford, Yugar, Sunshine Coast.

© 2023 by Starbyder Bookkeeping Pty Ltd. Powered and secured by Wix

bottom of page