December 2019 Sydney Sunrise & Sunset Times for Call Sheets

Call sheets often list First Light/Dawn, Sunrise, Sunset and Dusk/Last Light times.

Best practice is to calculate them for your shooting location. I’ve provided Sydney for December 2019 below.

SYDNEY Lat=-33°52’00” Long=+151°12’00”
TIMES OF SUNRISE AND SUNSET (for ideal horizon & meteorological conditions)

AT Astronomic Twilight = Centre mass of Sun is 18° below the horizon. Light pollution prevents astronomy.
NT Nautical Twilight = Centre mass of Sun is 12° below the horizon. Horizon can normally be distinguished.
CT Civil Twilight = Centre mass of Sun is 6° below the horizon. Normally enough light to see without artificial light.
Transit Time when Sun is highest in the sky.

AT riseNT riseCT riseSunriseTransitSunsetCT setNT setAT set
2019-12-01035604340509053712441951201920542132
2019-12-02035604340509053712441951202020552133
2019-12-03035604340509053712451952202120562134
2019-12-04035504330508053712451953202220572135
2019-12-05035504330508053712461954202320582136
2019-12-06035504330508053712461955202420592137
2019-12-07035404330508053712461956202521002138
2019-12-08035404330508053712471956202521012139
2019-12-09035404330508053712471957202621022140
2019-12-10035404330508053712481958202721032141
2019-12-11035404330509053812481959202821032142
2019-12-12035404330509053812492000202921042143
2019-12-13035404330509053812492000202921052144
2019-12-14035404330509053812502001203021062145
2019-12-15035404340509053812502002203121062146
2019-12-16035504340510053912512002203121072146
2019-12-17035504340510053912512003203221082147
2019-12-18035504340510053912512004203321082148
2019-12-19035604350511054012522004203321092148
2019-12-20035604350511054012522005203421102149
2019-12-21035604360512054112532005203421102150
2019-12-22035704360512054112532006203521112150
2019-12-23035704370513054212542006203521112151
2019-12-24035804370513054212542007203621122151
2019-12-25035904380514054312552007203621122151
2019-12-26035904380514054312552007203721122152
2019-12-27040004390515054412562008203721132152
2019-12-28040104400516054512562008203721132152
2019-12-29040104400516054512572009203821132153
2019-12-30040204410517054612572009203821142153
2019-12-31040304420518054712582009203821142153

Computed using National Mapping Division’s sunrisenset program, version 2.2
Licensed under the Creative Commons Attribution 3.0 Australia Licence.

Here is 2019:

Update: While I work out how to make this easily available, here’s a CSV file of Sydney Dawn, Sunrise, Transit, Sunset & Dusk time data for 2019. That’s all of 2019 and a bonus for January 2020.

Melbourne Cup in not a National Holiday

Nup to the Cup horseracingkills.com

Just a reminder that the Melbourne Cup is not a National Holiday in Australia. It is a Holiday for Melbourne (and some parts of Victoria I believe). Other Victorian regions get their own “cup day” holiday.

However much of Australia has a long lunch, or even a party to watch the race. So there goes an afternoon of work in most places.

NSW-based filming is normally not affected by the Melbourne Cup.

Personally I’m Nup to the Cup guy. I don’t attend counter-programming as I think a boycott needs to not recognise the actual bloody event. I also don’t begrudge someone else’s decision to enjoy the event.

November 2019 Sydney Sunrise & Sunset Times for Call Sheets

Call sheets often list First Light/Dawn, Sunrise, Sunset and Dusk/Last Light times.

Best practice is to calculate them for your shooting location. I’ve provided Sydney for November 2019 below.

SYDNEY Lat=-33°52’00” Long=+151°12’00”
TIMES OF SUNRISE AND SUNSET (for ideal horizon & meteorological conditions)

AT Astronomic Twilight = Centre mass of Sun is 18° below the horizon. Light pollution prevents astronomy.
NT Nautical Twilight = Centre mass of Sun is 12° below the horizon. Horizon can normally be distinguished.
CT Civil Twilight = Centre mass of Sun is 6° below the horizon. Normally enough light to see without artificial light.
Transit Time when Sun is highest in the sky.

AT riseNT riseCT riseSunriseTransitSunsetCT setNT setAT set
2019-11-01042404570529055512391922194920212054
2019-11-02042304560528055412391923195020222055
2019-11-03042104550527055312391924195120232056
2019-11-04042004540526055212391925195220242057
2019-11-05041904530525055212391926195320252059
2019-11-06041804520524055112391927195420262100
2019-11-07041704510523055012391928195520272101
2019-11-08041504500522054912391929195620282103
2019-11-09041404490521054812391930195720292104
2019-11-10041304480520054712391931195820312105
2019-11-11041204470520054712391932195920322106
2019-11-12041104460519054612391933200020332108
2019-11-13041004450518054512391934200120342109
2019-11-14040904440517054512401935200220352110
2019-11-15040804430516054412401936200320362112
2019-11-16040704420516054312401937200420372113
2019-11-17040604420515054312401938200520392114
2019-11-18040504410514054212401938200620402115
2019-11-19040404400514054212411939200720412117
2019-11-20040304400513054112411940200820422118
2019-11-21040304390513054112411941200920432119
2019-11-22040204380512054012411942201020442121
2019-11-23040104380512054012411943201120452122
2019-11-24040004370511053912421944201220462123
2019-11-25040004370511053912421945201320482124
2019-11-26035904360510053912421946201420492126
2019-11-27035804360510053812431947201520502127
2019-11-28035804350510053812431948201620512128
2019-11-29035704350509053812431949201720522129
2019-11-30035704340509053812441950201820532131

Computed using National Mapping Division’s sunrisenset program, version 2.2
Licensed under the Creative Commons Attribution 3.0 Australia Licence.

Planning ahead? Here is 2019:

Update: While I work out how to make this easily available, here’s a CSV file of Sydney Dawn, Sunrise, Transit, Sunset & Dusk time data for 2019. That’s all of 2019 and a bonus for January 2020.

October 2019 Sydney Sunrise & Sunset Times for Call Sheets

Call sheets often list First Light/Dawn, Sunrise, Sunset and Dusk/Last Light times.

Best practice is to calculate them for your shooting location. I’ve provided Sydney for October 2019 below.

SYDNEY Lat=-33°52’00” Long=+151°12’00”
TIMES OF SUNRISE AND SUNSET (for ideal horizon & meteorological conditions)

AT = Astronomic Twilight = Centre mass of Sun is 18° below the horizon. Light pollution prevents astronomy.
NT= Nautical Twilight = Centre mass of Sun is 12° below the horizon. Horizon can normally be distinguished.
CT= Civil Twilight = Centre mass of Sun is 6° below the horizon. Normally enough light to see without artificial light.
Transit = Time when Sun is highest in the sky.

AT riseNT riseCT riseSunriseTransitSunsetCT setNT setAT set
2019-10-01040904390508053311451757182218521921
2019-10-02040704370507053211451758182318521922
2019-10-03040604360505053011451759182418531923
2019-10-04040404340504052911441759182518541924
2019-10-05040304330502052811441800182518551925
2019-10-06050105310601062612441901192619562026
2019-10-07050005300600062512431902192719572027
2019-10-08045805290558062412431902192819572028
2019-10-09045705270557062212431903192819582029
2019-10-10045505260556062112421904192919592030
2019-10-11045405240554062012421905193020002031
2019-10-12045205230553061812421906193120012032
2019-10-13045105220552061712421906193220022033
2019-10-14044905200550061612411907193320032034
2019-10-15044805190549061412411908193320042035
2019-10-16044605170548061312411909193420042036
2019-10-17044505160546061212411910193520052037
2019-10-18044305150545061112411910193620062038
2019-10-19044205130544061012401911193720072039
2019-10-20044105120543060812401912193820082040
2019-10-21043905110541060712401913193920092041
2019-10-22043805090540060612401914194020102042
2019-10-23043605080539060512401915194020112043
2019-10-24043505070538060412401915194120122044
2019-10-25043305060537060312391916194220132045
2019-10-26043205040535060212391917194320142047
2019-10-27043105030534060012391918194420152048
2019-10-28042905020533055912391919194520162049
2019-10-29042805010532055812391920194620172050
2019-10-30042705000531055712391921194720182051
2019-10-31042504580530055612391922194820202053

Computed using National Mapping Division’s sunrisenset program, version 2.2
Licensed under the Creative Commons Attribution 3.0 Australia Licence.

September 2019 Sydney Sunrise & Sunset Times for Call Sheets

Call sheets often list First Light/Dawn, Sunrise, Sunset and Dusk/Last Light times.

Best practice is to calculate them for your shooting location. I’ve provided Sydney for September 2019 below.

SYDNEY Lat=-33°52’00” Long=+151°12’00”
TIMES OF SUNRISE AND SUNSET (for ideal horizon & meteorological conditions)

AT = Astronomic Twilight = Centre mass of Sun is 18° below the horizon. Light pollution prevents astronomy.
NT= Nautical Twilight = Centre mass of Sun is 12° below the horizon. Horizon can normally be distinguished.
CT= Civil Twilight = Centre mass of Sun is 6° below the horizon. Normally enough light to see without artificial light.
Transit = Time when Sun is highest in the sky.

DateAT riseNT riseCT riseSunriseTransitSunsetCT setNT setAT set
2019-09-0104:5105:2005:4906:1411:5517:3718:0218:3119:00
2019-09-0204:5005:1905:4806:1311:5517:3718:0218:3119:00
2019-09-0304:4905:1805:4706:1211:5517:3818:0318:3219:01
2019-09-0404:4705:1605:4506:1011:5417:3918:0418:3319:02
2019-09-0504:4605:1505:4406:0911:5417:3918:0418:3319:02
2019-09-0604:4505:1405:4306:0811:5417:4018:0518:3419:03
2019-09-0704:4305:1205:4106:0611:5317:4118:0618:3519:04
2019-09-0804:4205:1105:4006:0511:5317:4118:0618:3519:04
2019-09-0904:4105:1005:3906:0411:5317:4218:0718:3619:05
2019-09-1004:3905:0805:3706:0211:5217:4318:0818:3719:06
2019-09-1104:3805:0705:3606:0111:5217:4318:0818:3719:06
2019-09-1204:3705:0605:3405:5911:5217:4418:0918:3819:07
2019-09-1304:3505:0405:3305:5811:5117:4518:1018:3919:08
2019-09-1404:3405:0305:3205:5711:5117:4518:1018:3919:08
2019-09-1504:3205:0105:3005:5511:5117:4618:1118:4019:09
2019-09-1604:3105:0005:2905:5411:5017:4718:1218:4119:10
2019-09-1704:2904:5905:2805:5211:5017:4818:1218:4119:11
2019-09-1804:2804:5705:2605:5111:5017:4818:1318:4219:11
2019-09-1904:2704:5605:2505:5011:4917:4918:1418:4319:12
2019-09-2004:2504:5405:2305:4811:4917:5018:1418:4319:13
2019-09-2104:2404:5305:2205:4711:4917:5018:1518:4419:13
2019-09-2204:2204:5205:2105:4511:4817:5118:1618:4519:14
2019-09-2304:2104:5005:1905:4411:4817:5218:1718:4619:15
2019-09-2404:1904:4905:1805:4311:4817:5218:1718:4619:16
2019-09-2504:1804:4705:1605:4111:4717:5318:1818:4719:17
2019-09-2604:1604:4605:1505:4011:4717:5418:1918:4819:17
2019-09-2704:1504:4405:1405:3911:4617:5418:1918:4919:18
2019-09-2804:1304:4305:1205:3711:4617:5518:2018:4919:19
2019-09-2904:1204:4105:1105:3611:4617:5618:2118:5019:20
2019-09-3004:1004:4005:0905:3411:4517:5718:2218:5119:21

Computed using National Mapping Division’s sunrisenset program, version 2.2
Licensed under the Creative Commons Attribution 3.0 Australia Licence.

August 2019 Sydney Sunrise & Sunset Times for Callsheets

Call sheets often list First Light/Dawn, Sunrise, Sunset and Dusk/Last Light times.

Best practice is to calculate them for your shooting location. I’ve provided Sydney for August 2019 below.

SYDNEY Lat=-33°52’00” Long=+151°12’00”
TIMES OF SUNRISE AND SUNSET (for ideal horizon & meteorological conditions)

AT Astronomic Twilight = Centre mass of Sun is 18° below the horizon. Light pollution prevents astronomy.
NT Nautical Twilight = Centre mass of Sun is 12° below the horizon. Horizon can normally be distinguished.
CT Civil Twilight = Centre mass of Sun is 6° below the horizon. Normally enough light to see without artificial light.
Transit Time when Sun is highest in the sky.

DateAT riseNT riseCT riseSunriseTransitSunsetCT setNT setAT set
2019-08-0105:2205:5206:2206:4812:0217:1517:4218:1218:41
2019-08-0205:2105:5106:2106:4712:0217:1617:4218:1218:42
2019-08-0305:2105:5006:2006:4612:0117:1717:4318:1318:42
2019-08-0405:2005:4906:1906:4612:0117:1717:4418:1318:43
2019-08-0505:1905:4906:1806:4512:0117:1817:4418:1418:44
2019-08-0605:1805:4806:1806:4412:0117:1917:4518:1518:44
2019-08-0705:1805:4706:1706:4312:0117:1917:4618:1518:45
2019-08-0805:1705:4606:1606:4212:0117:2017:4618:1618:45
2019-08-0905:1605:4506:1506:4112:0117:2117:4718:1718:46
2019-08-1005:1505:4406:1406:4012:0117:2217:4718:1718:46
2019-08-1105:1405:4306:1306:3912:0117:2217:4818:1818:47
2019-08-1205:1305:4206:1206:3812:0017:2317:4918:1818:48
2019-08-1305:1205:4106:1106:3712:0017:2417:4918:1918:48
2019-08-1405:1105:4006:1006:3612:0017:2417:5018:2018:49
2019-08-1505:1005:3906:0906:3512:0017:2517:5118:2018:49
2019-08-1605:0905:3806:0806:3412:0017:2617:5118:2118:50
2019-08-1705:0805:3706:0706:3211:5917:2617:5218:2118:51
2019-08-1805:0705:3606:0606:3111:5917:2717:5318:2218:51
2019-08-1905:0605:3506:0506:3011:5917:2817:5318:2318:52
2019-08-2005:0505:3406:0406:2911:5917:2817:5418:2318:52
2019-08-2105:0405:3306:0206:2811:5917:2917:5518:2418:53
2019-08-2205:0305:3206:0106:2711:5817:3017:5518:2518:54
2019-08-2305:0205:3106:0006:2611:5817:3117:5618:2518:54
2019-08-2405:0105:3005:5906:2411:5817:3117:5718:2618:55
2019-08-2505:0005:2905:5806:2311:5817:3217:5718:2618:55
2019-08-2604:5805:2705:5706:2211:5717:3317:5818:2718:56
2019-08-2704:5705:2605:5506:2111:5717:3317:5918:2818:57
2019-08-2804:5605:2505:5406:1911:5717:3417:5918:2818:57
2019-08-2904:5505:2405:5306:1811:5617:3518:0018:2918:58
2019-08-3004:5405:2305:5206:1711:5617:3518:0118:3018:58
2019-08-3104:5205:2105:5006:1611:5617:3618:0118:3018:59

Computed using National Mapping Division’s sunrisenset program, version 2.2
Licensed under the Creative Commons Attribution 3.0 Australia Licence.

Industrial Awards and Agreements in NSW

Industrial Awards and Agreements cover motion picture production in NSW and Australia. They include

  • Actor’s Feature Film Collective Agreement (AFFCA) 2012
  • Motion Picture Production Agreement (MPPA) 2010 ^
  • Broadcasting, Recorded Entertainment and Cinemas Award 2010 *
  • 2018 In-Principle Offshore Agreement **

Motion picture production covers not only film, television and television commercial production, but also web streaming shows, and even “indie” features.

Deferral contracts are illegal under NSW and Australian Employment law. If you are employed to work on a motion picture, in all likelihood you are an employee. Employees in Australia must be paid. Any producer who tries to contract out of employment law is making themselves liable for claims down the road.

There may be a legal way to make a feature film without employing the cast and crew but I’m not going to publicly speculate about it here. Get in touch if you have an absolutely brilliant idea that can only be made this way and we’ll discuss it.

^ Technically there are two published versions of the Pay Rates under MPPA, one put out by MEAA that won’t get you in legal hot water, and one published by SPA which may get you a date with the Fair Work Ombudsman. Note that there is no agreement between MEAA and SPA on this agreement since it expired in 2013.

* I have never met a professional crew-member who works under the BRECA.

** In-principle agreement between MEAA and the six major studios (Paramount, Sony, Fox, Universal, Disney and Warner Bros). NB: Disney now owns Fox.

July 2019 Sydney Sunrise & Sunset Times for Callsheets

Call sheets often list First Light/Dawn, Sunrise, Sunset and Dusk/Last Light times.

Best practice is to calculate them for your shooting location. I’ve provided Sydney for July 2019 below.

SYDNEY Lat=-33°52’00” Long=+151°12’00”
TIMES OF SUNRISE AND SUNSET (for ideal horizon & meteorological conditions)

AT = Astronomic Twilight = Centre mass of Sun is 18° below the horizon. Light pollution prevents astronomy.
NT= Nautical Twilight = Centre mass of Sun is 12° below the horizon. Horizon can normally be distinguished.
CT= Civil Twilight = Centre mass of Sun is 6° below the horizon. Normally enough light to see without artificial light.
Transit = Time when Sun is highest in the sky.

DateAT riseNT riseCT riseSunriseTransitSunsetCT setNT setAT set
2019-07-0105:3206:0206:3307:0111:5916:5717:2517:5618:26
2019-07-0205:3206:0206:3307:0111:5916:5717:2517:5618:26
2019-07-0305:3206:0206:3307:0111:5916:5817:2517:5618:27
2019-07-0405:3206:0206:3307:0112:0016:5817:2617:5718:27
2019-07-0505:3206:0206:3307:0112:0016:5917:2617:5718:28
2019-07-0605:3206:0206:3307:0112:0016:5917:2717:5818:28
2019-07-0705:3206:0206:3307:0112:0017:0017:2717:5818:28
2019-07-0805:3206:0206:3307:0012:0017:0017:2817:5918:29
2019-07-0905:3106:0206:3307:0012:0017:0117:2817:5918:29
2019-07-1005:3106:0206:3207:0012:0117:0117:2918:0018:30
2019-07-1105:3106:0106:3207:0012:0117:0217:2918:0018:30
2019-07-1205:3106:0106:3206:5912:0117:0217:3018:0018:31
2019-07-1305:3106:0106:3206:5912:0117:0317:3018:0118:31
2019-07-1405:3006:0106:3106:5912:0117:0317:3118:0118:32
2019-07-1505:3006:0006:3106:5812:0117:0417:3118:0218:32
2019-07-1605:3006:0006:3106:5812:0117:0517:3218:0318:33
2019-07-1705:3006:0006:3006:5712:0117:0517:3218:0318:33
2019-07-1805:2905:5906:3006:5712:0117:0617:3318:0418:34
2019-07-1905:2905:5906:2906:5712:0217:0617:3418:0418:34
2019-07-2005:2805:5806:2906:5612:0217:0717:3418:0518:35
2019-07-2105:2805:5806:2906:5512:0217:0817:3518:0518:35
2019-07-2205:2805:5806:2806:5512:0217:0817:3518:0618:36
2019-07-2305:2705:5706:2706:5412:0217:0917:3618:0618:36
2019-07-2405:2705:5706:2706:5412:0217:1017:3718:0718:37
2019-07-2505:2605:5606:2606:5312:0217:1017:3718:0818:37
2019-07-2605:2605:5506:2606:5212:0217:1117:3818:0818:38
2019-07-2705:2505:5506:2506:5212:0217:1217:3818:0918:38
2019-07-2805:2505:5406:2406:5112:0217:1217:3918:0918:39
2019-07-2905:2405:5406:2406:5012:0217:1317:4018:1018:40
2019-07-3005:2305:5306:2306:5012:0217:1417:4018:1018:40
2019-07-3105:2305:5206:2206:4912:0217:1517:4118:1118:41

Computed using National Mapping Division’s sunrisenset program, version 2.2
Licensed under the Creative Commons Attribution 3.0 Australia Licence.

June 2019 Sydney Sunrise & Sunset Times for Callsheets

Call sheets often list First Light/Dawn, Sunrise, Sunset and Dusk/Last Light times.

Best practice is to calculate them for your shooting location. I’ve provided Sydney for June 2019.

SYDNEY Lat=-33°52’00” Long=+151°12’00”
TIMES OF SUNRISE AND SUNSET (for ideal horizon & meteorological conditions)

AT = Astronomic Twilight = Centre mass of Sun is 18° below the horizon. Light pollution prevents astronomy.
NT= Nautical Twilight = Centre mass of Sun is 12° below the horizon. Horizon can normally be distinguished.
CT= Civil Twilight = Centre mass of Sun is 6° below the horizon. Normally enough light to see without artificial light.
Transit = Time when Sun is highest in the sky.

DateAT riseNT riseCT riseSunriseTransitSunsetCT setNT setAT set
2019-06-0105:2305:5306:2406:5111:5316:5517:2217:5318:23
2019-06-0205:2405:5406:2506:5211:5316:5417:2217:5318:23
2019-06-0305:2405:5406:2506:5311:5316:5417:2117:5218:23
2019-06-0405:2405:5506:2606:5311:5316:5417:2117:5218:22
2019-06-0505:2505:5506:2606:5411:5416:5417:2117:5218:22
2019-06-0605:2505:5606:2706:5411:5416:5317:2117:5218:22
2019-06-0705:2605:5606:2706:5511:5416:5317:2117:5218:22
2019-06-0805:2605:5706:2806:5511:5416:5317:2117:5218:22
2019-06-0905:2705:5706:2806:5611:5416:5317:2117:5218:22
2019-06-1005:2705:5706:2906:5611:5516:5317:2117:5218:22
2019-06-1105:2705:5806:2906:5711:5516:5317:2117:5218:22
2019-06-1205:2805:5806:2906:5711:5516:5317:2117:5218:22
2019-06-1305:2805:5906:3006:5711:5516:5317:2117:5218:22
2019-06-1405:2905:5906:3006:5811:5516:5317:2117:5218:22
2019-06-1505:2905:5906:3106:5811:5616:5317:2117:5218:22
2019-06-1605:2906:0006:3106:5911:5616:5317:2117:5218:22
2019-06-1705:2906:0006:3106:5911:5616:5317:2117:5218:23
2019-06-1805:3006:0006:3106:5911:5616:5317:2117:5218:23
2019-06-1905:3006:0106:3206:5911:5616:5317:2117:5218:23
2019-06-2005:3006:0106:3207:0011:5716:5417:2117:5318:23
2019-06-2105:3106:0106:3207:0011:5716:5417:2217:5318:23
2019-06-2205:3106:0106:3207:0011:5716:5417:2217:5318:23
2019-06-2305:3106:0106:3307:0011:5716:5417:2217:5318:24
2019-06-2405:3106:0206:3307:0111:5816:5517:2217:5318:24
2019-06-2505:3106:0206:3307:0111:5816:5517:2217:5418:24
2019-06-2605:3106:0206:3307:0111:5816:5517:2317:5418:24
2019-06-2705:3206:0206:3307:0111:5816:5517:2317:5418:25
2019-06-2805:3206:0206:3307:0111:5816:5617:2317:5518:25
2019-06-2905:3206:0206:3307:0111:5916:5617:2417:5518:25
2019-06-3005:3206:0206:3307:0111:5916:5617:2417:5518:26

Computed using National Mapping Division’s sunrisenset program, version 2.2
Licensed under the Creative Commons Attribution 3.0 Australia Licence.

Screen Australia A-Z Budget templates

Screen Australia A-Z Feature Budget

Update 23 Sep 2024. I’ve fixed the issue and can again share a template. But there are still issues with importing your budget into Xero. Comment below and I’ll email to set up a no obligation chat to understand your needs (and get an idea about indie production in Australia).

Screen Australia provides a standard spreadsheet template for all their funding applications. This is known as the A-Z Budget and is a long-standing standard in Australian Film & TV production. It is an essential tool if you are going to apply for the Producer Offset. The current A-Z Feature Budget is version 7.7.

WARNING: ScreenAustralia change the template without updating the version number. In the Budget tab, text TOTAL BUDGET used to be in cell B1558 now it’s B1560.

Once there is more than one bookkeeper or payroll master the accounts must be kept in a proper system. If you want to import that A-Z Budget chart of accounts into any professional accounts system you are in for hours or days of manual manipulation and pain.

I’ve gone through this too many times so I’ve made a csv file that has account codes and budget categories to match v7.7. This should allow you to set up an A-Z Budget chart of accounts in MYOB, Xero, QuickBooks and other accounting packages. Just ask in the comments and I’ll email it to you, remember to tell me what accounting package you are setting up. Sorry I need to talk to you now to make sure it will work.

STOP PRESS: Xero has a 999-line limit on the import, so you can’t import it the whole Chart of Accounts. I’m working on a fix. I’ve fixed it.

There is a version of the A-Z Budget in Movie Magic Budgeting 7 but it is hopelessly broken and out of date. I have created a working file for MM Budgeting 7 for my clients. Sorry it’s also broken now and I can’t fix it as I no longer have MMB7 to play with. Let me know if you have a license I can use to fix it.

Specific criticisms of theA-Z Budget Spreadsheet follow. Scroll down to the comments if you want to skip the painful details.

The A-Z Budget spreadsheet has a terrible User Interface (UI) and User Experience (UX). That is not the end of the world as, once you get used to it, you can navigate around the ugly beast. Did I mention the Budget tab defaults to 1558 1560 lines before dealing with 14 separate detail tabs?

This spreadsheet has grown over the years with many owners and target uses. Therefore it is absolutely Byzantine in structure and layout. Budget categories are coded A to Z (hence the name) with some having logical structure e.g. C.1-C.24 under C. PRODUCTION UNIT FEES & SALARIES.

But C.16 VISUAL EFFECTS & ANIMATION does not have the word “Crew” that most of the departments have. That’s the sort of sloppiness that creeps into legacy systems when they get updated. When the A-Z Budget was developed there was no Visual Effects Crew only practical special effects.

Worse is U IMAGE POST-PRODUCTION whose subcategories go from a. to n. with no reference to the U parent, it just suddenly jumps from U on row 1285 to a. on row 1289 all the way to n. on row 1375. It’s easy to get lost. The same thing happens again at V SOUND – POST PRODUCTION, suddenly we have a. to e. disconnected from the parent account.

How about Above-The-Line E(a) PRINCIPAL CAST with subcategories E(a)1 OFFSHORE CAST – Non-resident and E(a)2 AUSTRALIAN CAST – Australian residents. At least you know there is an E category with subcategory (a) and then 2 sub-subcategories.

Below-The-Line we start with C. and D. before returning to E(b) CAST & CASTING made up of subcategories E(b)1 CASTING FEES & EXPENSES to E(b)6 EXTRAS. Why is it E(b)1 when elsewhere it is C.1 or F.2 or U.2 or L. or R. or n. or any other arbitrary format structure?

This is why you can’t just import the unmodified A-Z Budget. Not rational accounting system understands the accounting levels Screen Australia has created for us.

There’s a whole different post coming on accounting for QAPE (Qualifying Australian Production Expenditure) which you require if you will apply for the Producer Offset.