Logbook instructions

The ULTIMATE Logbook instructions page

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

The following is the pre-recorded instructions on using this logbook. Remember to pause as you watch to help you with your document at the same time. Also below is more information on the changes to the current version, screen prints and FAQs.

This document includes the components for AHPRA report, with a easy to use format, with auto-calculations throughout. Watch the recording, and get started.

New features in this version

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.4C) which includes:

  • Additional columns for the 5+1 Provisionals on the tab 3 part B PD for your reflections

  • All supervision tabs no longer has the outline feature as code has changed this to just show you the 4+2 or 5+1 content

  • Your Summary tab - has a new summary up the top for this week, last week and overall internship numbers for a quick review

  • New tab - Supervisor letter. This is handy to send your supervisor a quick update on your numbers/progress

  • new tab - Portfolio Additional. This is a place you can paste any documents relevant for the week.

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