Hey, it’s Terry here. Happy Tuesday!

I’m feeling excited this week for my first Crossfit Open in about 7 years! What is it? Well it means I’ll be busting my arse in a world wide Crossfit competition. Not with the aim of getting a high ranking in my age group because I do mostly scaled versions of movements, but to get out of my comfort zone and then give myself a pat on the back.

Are there benefits to getting out of your comfort zone? Absolutely! It increases your resilience, grit and confidence and is great for brain power for problem solving. It also helps reduce the fear of failure which results in you not having a go at something that you may regret not doing later on in life. So this weeks challenge:

πŸƒπŸ½β€β™€οΈβ€βž‘οΈπŸ’₯πŸ€ͺπŸ‹πŸ½β€β™€οΈGet out of your comfort zone!πŸŽ€πŸ•·οΈπŸ§˜πŸ½β€β™€οΈπŸš΅πŸ½β€β™‚οΈ

If you know a small business who needs help with their bookkeeping and admin, please tell them about me, I’d be most grateful. My website is qwertyplus.com.au, check it out if you like. I’m also on Facebook. Thanks in advance! πŸ™πŸΌ

In this week’s issue:

  • Outlook- Add a comment/reminder for yourself to an email. πŸ“¨

  • Excel - freeze rows, columns or both.

  • Word; - don’t do heaps of blank lines, insert a page break instead! πŸ“„

  • What is a pilcrow? πŸ€·πŸ½β€β™‚οΈ

  • Xero - cash coding - the fast way to reconcile your bank. But take care!

  • Major changes to superannuation are around the corner 🫣

  • pay.com.au and Shopback - what are they?

Did someone share this email with you? Sign up here and get your own email every week!

TECHNOLOGY

πŸ‘‰πŸ½Outlook - Add a comment/reminder to an email in your inbox

I find this tip really handy for an email you’ve received that has something really important in it, you don’t want to forget why it’s still in your inbox, or my might need to action it later on.

You’re actually β€œediting” the email and adding a comment or reminder. Remember though, if you end up replying to the sender, delete your message before replying.

  1. Double click the email so it’s in it’s own window.

  2. In the top menu bar in the Move section, click on Actions / Edit Message.

  3. Add your reminder/comment at the top of the email.

  4. Format it in really large font and highlight so it’s hard to miss!

  5. Click Save in the top left corner.

Every time you click on the email it will now show your reminder/comment.

Add comment / reminder to an email in your inbox

~~~~~~~~~~~~~~~~~~

❄️Excel - freeze rows and columns to always see headings

If your spreadsheet is large enough that you have to scroll down, there are 2 ways to freeze your headings so you don’t lose sight of them.

  1. Freeze the top row:

    1. Highlight row 1. Not just the cells but the entire row.

    2. View menu at the top, Window group/click on Freeze Panes/Freeze Top Row. Same location to unfreeze the row.

    3. You can do the same for the first column A.

  2. Freeze multiple top rows:

    1. Say you want to freeze the first 5 rows. Click in cell A6

    2. View menu at the top, Window group/click on Freeze Panes/Freeze Panes again. Same location to unfreeze the rows.

    3. You can do the same for multiple columns.

  3. Freeze multiple rows and columns:

    1. Say you want to freeze the first 2 rows and first 2 columns. Click in cell C3

    2. View menu at the top, Window group/click on Freeze Panes/Freeze Panes again. Same location to unfreeze the rows and columns.

~~~~~~~~~~~~~~~~~~

πŸ“ƒWord - insert a page break

If you want to add content on the next page don’t press the space bar multiple times to go to the next page. Instead insert a page break, and you’ll automatically go the next page.

  1. If you’re ready to go to a new page, ensure your cursor is on a new line at the bottom of the content of the page you’re on.

  2. Go to the top menu Insert / Pages group / Page Break. You’ll now be on the next page.

  3. If you want to see where you page breaks are in a large document:

    1. On the Home tab, click on the pilcrow symbol to Show/Hide formatting. Have you ever heard that word before? I had to Google what it was called πŸ€·πŸ½β€β™€οΈπŸ˜

~~~~~~~~~~~~~~~~~~

Xero - cash coding

If your access level allows you to do your bank reconciliation with the Cash Coding feature, you can save a ton of time for spend money and receive money transactions! It’s great for multiple transactions for the same thing, eg bank fees, fuel, materials (eg over the counter eftpos purchases as Bunnings).

  1. In the home screen, click on the reconcile button for the bank account.

  2. Select the Cash coding tab. If you don’t see it, you don’t have access to it. 😒

  3. Sort by Payee column to get the same suppliers grouped together.

  4. Now follow the video below. You can also select multiple tick boxes by ticking the first box, hold down the Shift key, tick the last box. I could have done that with the video example Central City Parking.

⚠️Don’t Cash Code any transactions that have bills sitting in Payables, or invoices sitting in Sales. Reconcile them as usual.

Divider

πŸ”¦Major change to super rules πŸ”¦

From 1 July 2026, employers have to pay super every pay period - eg weekly or fortnightly. No more once a quarter payments. This is a major step by the ATO in cracking down on employers not paying super.

For employees: Keep track of your super payments on your ATO Online Services portal via myGov, and if your employer isn’t paying them at least quarterly now, and every pay period from 1 July, get on to them fast! Sure you might be a long way off 67 and retiring, but every dollar adds up.

If your employer puts $10,000 in a super fund this year, as a conservative estimate, in 30 years time it could be worth $60,000-$100,000, and that’s just one year of super contributions. So you don’t want to miss out on any contributions.

For employers: The big thing to remember here is that in July you need to pay the June quarter super (due 28 July), and also super on every payrun in July. So could be a big dip in your cash flow.

Start planning now and consider now paying super with each payroll. Or at the very least, do a cash flow forecast so you can meet your super obligations in July.

🫰🏽pay.com.au and Shopback

What are they and are they worth it?

pay.com.au

This portal seems to be gaining popularity with businesses because you can link your bank accounts and credit cards to the site, and pay your bills. The β€œbenefit” is that you can earn points and use them to buy travel or products.

You can double dip and earn points by paying a bill with a credit card that has a points system attached to it. pay.com.au gives you points (but they’ll charge you a fee) and your credit card will also give you points, eg Qantas Frequent Flyer but they’ll charge you a fee as well.

Example: Pay phone bill on pay.com.au using your bank credit card that has Qantas Frequent Flyer.

  • pay.com.au will charge a fee and you’ll earn points

  • bank credit card will also charge a fee and you’ll also earn points from them.

Most comments I’ve read by users say you’ll be in front when you cash in your points, particularly for business class travel. But you’re paying a lot in fees upfront and perhaps not travelling for some time (when you’ve accrued sufficient points for that business class seat).

You can even pay the ATO with your Amex via pay.com.au.

I believe it’s worth investigating and running your own numbers to see if it will work for you.

Shopback

I’ve used the Shopback app for about 7 years for online purchases and my lifetime earnings is over $1,500 just for shopping on sites I would normally shop at anyway. Prices are the same, just make sure the Shopback link is showing at the top of the browser window.

With Shopback credit you can transfer it to your bank account when it gets unlocked. Say you bought hotel accommodation, it wouldn’t be unlocked until after your stay when it’s definite that the accommodation wasn’t cancelled.

It’s great for saving up cash for Christmas! I need parking and accommodation in May and Shopback currently has up to 15% cash back. So I’ll go into Shopback, click on the links to purchase online, then after my travel in May, I’ll get up to 15% cash back (depending on who I book through) deposited into my Shopback account.

Here’s a link if you want to sign up to Shopback and get $20 free credit (I get it too), but do your own research before you sign up. Don’t just take my word for it. 😊

TUESDAY VIBES

Non-productive but 100% boss-approved (maybe)

I just had to share this photo with you, a couple of flowers bloomed this morning on our cactus, with two more due in a couple of days. They last less than a day! Did you know every cactus flowers?

Before you go…

πŸ’» Want to share a thought or tip with our readers?

Click on the Comments button at the top of this post!

Have a wonderful week, take care and be super grateful for your family, colleagues and friends.

Terry-Anne
Founder & Editor, Qwerty Plus Newsletter

Reply

Avatar

or to participate

Keep Reading