Logbook instructions

The 5+1 ULTIMATE Logbook instructions page

This page includes the recordings on how to use, and additional information below to help you get started.

Remember to pause as you watch so you can se up your document at the same time.

How to download and save your logbook

In this brief recording we provide you with some instructions to help you download and save your newly purchased logbook. Once you have this saved, please go to the next recording to learn how to use this logbook, including the important step of copy/paste value.

Quick overview of the changes in March 2025

If you have upgraded your logbook from to the March 2025 version, this brief recording walks you through the changes, and an important note on the first time you copy/paste values. Please note, this is important to watch to ensure your data is safety transferred.

How to enable Macros and what features work

We have 2 features in the logbook that work well if you decide to “enable macros”. They include: the date picker and multiple selecting of items for the client contact and client related. If you need help, watch this brief recording to help you use these features.

Full recording (below)

The recording below shows you how to use this document, including saving, copy/paste special, AHPRA progress report, supervisor summary and general orientation to this time saving document.

New features in this version - released March 2025 v2.6

While our logbook has everything auto-calculating, and it is easy to populate in client information, our latest version has a few tweaks to make this just a bit better again. In the video we discuss the new features of this version (2.6) which includes:

  • 100% designed for the 5+1 Provisionals Psychologists

  • New checkboxes for completed internship tasks

  • Your summary dashboard has new graphics and clearer, easier to read information on your progress

  • An overall internship totals for a quick review of what has been completed

  • Supervisor tab enhanced with graphics, better summary, case report numbers and observations in a printable format

  • If you have not yet purchased this document, go to: https://psychologysquared.com.au/logbook

Frequently Asked Questions

The following are some questions we get asked from time to time, and we provide information and also a screen print.


1. Does this logbook automatically ADD up my Total hours?

Yes! We have total sections on each page for client direct and client related, simulated hours, PD and supervision. You do not need to add anything manually. Below is a screen grab to show you how this looks in its graph form for client contact and client related (available for both 4+2 and 5+1 pathways).

2. How will I know if my supervision ratio is on track?

We have created an overall supervision ratio. The below automatically populates subject to what numbers are entered in your logbook. In the below example, we are short 8.49 hours of supervision.

3. Does this logbook separate out my simulated hours?

Yes! Below is one of many total sections in this document which shows you your real and simulated hours. You can see how you are tracking for the week and across your provisional journey.

4. What is the 6 monthly ahpra reporting like?

We have made this so easy. Below is from the logbook on the progress report tab. The yellow section is all that you need to fill in and the rest is automatic. Then you just need to get your AHPRA form, and fill it in.

5. Is this logbook only about the numbers?

We really wanted to support you with your provisional journey and therefore, we have added content to help you with things like what to talk about in supervision. We have a full list of topics and also ideas on Professional Practice issues.

6. I find logbooks exhausting. How is this going to make things easier?

One of the features of this logbook is that we have made space for you to store information such as your clients’ presentations. Below is how you can save your clients, then ALSO use it in your Part A section as a drop down list. No more typing in your client information each time.

Functionality tips

If you need more specific help and information, see below. Click on the + sign for more information and access to more tips!

  • To enable the calendar, and the multiple selection option, you need to enable macros whether using a Mac or PC. Click here for instructions:

    https://support.microsoft.com/en-us/office/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6 or

    https://www.ablebits.com/office-addins-blog/enable-disable-macros-excel/.

    If more information is needed, please send us an enquiry via our “ask a question” page: https://psychologysquared.com.au/ask-questions-your-interest-logbook and additional support can be offered.

    You can use the document without macros enabled, but the above mentioned features will not be available.

  • When using this logbook, it is SUPER IMPORTANT to use the right paste function when copying between weeks. The “paste” function often keeps formulas that will not apply to the new logbook. A “paste value” is what is needed as it removes all formulas and pastes only the numbers without referencing the previous logbook links. Here are some helpful article links:

    https://www.ablebits.com/office-addins-blog/excel-paste-special-shortcuts-features/#excel-paste-special or

    https://support.microsoft.com/en-us/office/paste-special-e03db6c7-8295-4529-957d-16ac8a778719

  • Throughout the document, on multiple pages, we have created dropdown lists to make completing this document easier. These lists are all editable or you can chose to enter your own data.

    On the PASTE tab, you can edit the supervisor list, the client list, the client contact/direction list and the client related list. Simply type over the content that is already there.

    Please note: if you delete or enter more information beyond the cells allocated, this may not work.

  • As this document is multi purposed for both the 4+2 and the 5+1 pathways, we have added to the supervision, summary and progress report tabs the outline feature. If you head to one of these pages, and see on the left hand side the + or - signs in the margin, you can hide the pathway that you do not need to see.

    Here is a link with more information on outlines in Excel: https://support.microsoft.com/en-us/office/outline-group-data-in-a-worksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff

  • On the Summary tab, there is a section to help you with your supervision ratio that you need to maintain for AHPRA.

    You do not need to edit the information, as it calculates it automatically based on the hours you enter elsewhere in the spreadsheet.

    You can refer to the graph or the numbers to know if you are above, below or on track.

    If you want to explore more about how many hours of work you need to do, book a session for one on one support using the “ask a question” page.

  • On the summary tab, when you scroll down paste the supervision ratio section, there are two different types of end date estimator.

    The first one requires you to enter in the yellow box the end date you might like to be finished by, and how many hours a day you think you will do each day. The spreadsheet then calculates how many hours per month, week and day you need to do to reach that target. Play with the date in the yellow box to see how these numbers change.

    The second formula, estimates an end date based on the work you have done each logbook to date, using a ratio formula. If over your provisional journey you have changed jobs or dramatically changed the hours you do, you may find this to be inaccurate. Therefore, use your judgement.

    Try them out and see which one is your preference.

  • Great news! Completing your 6 monthly progress report is now much simpler. You only need to enter the amounts from your previously submitted AHPRA report. If this is your first report to AHPRA, then you can leave the fields blank as the data on this page is automatic. We estimate the progress report amounts taking minutes to complete