Rabobank Direct Credit Export

In July 2020 Rabobank tightened their online banking security measures, which resulted in some of our users struggling to import the direct credit file from Cashmanager RURAL into their Rabobank account.

The default file extension .aba is no longer accepted by Rabobank. But by changing the file extension when you export the file, you'll be able to import it into your bank account.

Simply follow the instructions below:

How to change the file extension in Cashmanager RURAL

1. Click on Export - Direct Credits as you normally do.

2. Click into the File field and change the extension to .txt

3. Click OK to save the file.

4. Locate the file and import it into Rabobank as you normally do.

What if I've already exported the file?

1. Locate the file on your computer.

2. Right click on the file name and select Properties.

3. In the General tab, remove the extension .aba and replace it with .txt

4. Click OK.

5. Import the file into Rabobank as you normally do.

NOTE: you may see the following message when changing the file extension. Click Yes to continue.

Payday Filing and Single Touch Payroll in Cashmanager RURAL online

As legislative requirements become increasingly complex we believe the simple wagebook in Cashmanager RURAL may not meet your employer obligations in the future.

For this reason, we have made the decision not to update the wagebook to create returns for the following:

• Payday filing with IRD - (NZ)
• STP with ATO - (AUS)

Instead, we believe this is best left to specialist payroll providers such as PaySauce and Smart Payroll (NZ employers only).

We strongly recommend that you talk with your accounting specialist to determine the best payroll product for your business.

Cashmanager RURAL online installation troubleshooting

1. Windows Updates
Make sure your Windows updates are up to date and completed before installing the Cashmanager application.

2. Windows Defender security warning
If you get a Windows Defender security warning you can ignore it. Click on More info to remove the warning and Run anyway to complete the installation.

Can't find the downloaded file?

1. Check your Downloads folder
On new computers (Windows 7 and higher), items are downloaded automatically to your Downloads folder.
Locate the application from your Downloads folder and run it from there.

2. Check your anti-virus software
This may be preventing the application from being run from your Downloads folder.
Allowing your anti-virus software to recognise Cashmanager RURAL online as a safe application will let you install it.

3. Not in your Downloads folder?
Then try downloading it directly from our website.

• Exit from the Cashmanager RURAL online login page.
• Go to www.cashmanagerrural.nz.
• Log in using your email address and password for Cashmanager RURAL online.
• Click on the Install button and follow the prompts.

If you're still stuck after looking at these tips, please phone our Help Desk:
0800 888 080 (NZ)
1800 351 781 (AUS)

The Help Desk is open weekdays from 8.45am - 6.00pm (NZT).

How to record the Fonterra balancing retro in your plan

In early December 2018, Fonterra announced the new Advance Rate Schedule that saw the December '18 base Advance Rate set at $4.00, down from the previous rate of $4.15.

Simply put, this means that farmers will be paid $4.00 for all milk solids supplied in the month of December 2018, less a deduction of 15 cents on all of their milk solids supplied between June-November inclusive that have been paid at the $4.15 level.

We've suggested a couple of options below on how you could display this correctly in your working or draft plans

Option 1 (recommended)

Using the extended code Last Season's (LS) open a worksheet with a payment date of January 2019 in your working or draft plan.

Enter the total kg/MS that was produced between Jun to Nov in January e.g. 52,000 x .15 = -$7,950.00

Once January has finished, remove the amount you calculated for January from your plan.

Option 2

In the Dairy Forecaster, change the Base Adv Rate for supply months September - November from $4.15 to $4.00.

Everything will come out in the wash when the milk solids provided for the season to date are retrospectively paid in February.

Option 3

Create a new extended code under Milk Production for the Balancing Retro.
Make sure you set the code type to Expense.

Using the new extended code, open a worksheet with a payment date of January 2019 in your working or draft plan.

Enter the total kg/MS that was produced between Jun to Nov in January e.g. 52,000 x .15 = -$7,950.00

Finally, using the same extended code, enter the same amount as a credit in February.

Fuel excise duty rebates

What is fuel excise duty?

Excise duty is applied to all petrol sold in New Zealand and is collected to help fund safety upgrades, public transport, walking and cycling projects and regional roads.

If you buy and use petrol off-road within your business (for example, for use in your quad bike) you may be in for a fuel excise refund.

For more information, click on the links at the bottom of this article.

Does the refund include GST?

Rebates that you receive as a shareholder from Farmlands, Ravensdown, Ballance etc don't generally include GST (but it's always best to check with your accountant).

On the other hand, your Excise Duty refund is subject to GST and any refunds received should be included in the GST period it relates to.

How should I record it in Cashmanager?

When it comes to coding the transaction, we recommend that you create a new extended code within your Other Farm Income category specifically for excise fuel refunds.

In the Transactions screen, click on the Setup - Codes menu.

1. Highlight the Category code, Other Farm Income (OF).

2. Under the 'New' area, click on Extended Code.

3. Enter a Code and Description that make sense to you.

4. Set the GST to B (Business).

5. Set the Type to Income.

6. Click OK to save the changes.

More Information

NZTA - Excise Duty Refunds

Do-it-yourself
NZTA Fuel Excise Duty Refund Customer Registration Form
Application for Refund of Fuel Excise Duty

Get someone to do it for you
Catalyst Fuel Refunds
NZ Petrol Refunds
Fuel Rebates

Rural internet options

The New Zealand Government has a goal to connect 90 per cent of the population with 4G mobile coverage by the end of 2019, and 99 per cent of New Zealanders with access to 50 Mbps peak speeds by 2025 – more information.

USEFUL LINKS RELATING TO RURAL INTERNET OPTIONS:

National Broadband Map – click here to see what services are available at your address

Broadband Compare – click here to compare New Zealand’s best broadband deals for your address

Types of Internet connections – click here to read an article by consumer.org about the different types of connections

Is your Internet fit for purpose – click here to work out whether you have a decent internet speed

Wireless Internet Service Providers Association of New Zealand Inc (source: wispa.nz):

MEMBERS OF WISPA:

Nationwide
Connecta 0800 969 869 www.www.connecta.co.nz
GoWirelessNZ 03 741 1339 www.gowifi.co.nz
Inspire.net 0800 484 363 www.inspire.net.nz
Netspeed 0800 638 773 www.netspeed.net.nz
Ultimate Broadband 0800 000 945 www.ultimatebroadband.co.nz
VelocityNet 03 218 4489 www.velocitynet.co.nz
Wanna 0800 100 714 www.wanna.net.nz
Otago & Southland
---
Unifone 0800 894 114 www.unifone.net.nz
YRLess 0508 975 377 www.yrless.co.nz
Countrynet (03) 450 0030 www.countrynet.co.nz

Canterbury
Amuri.net 0800 002 643 www.amuri.net
Greater Nelson Region
---
Thepacific.net 03 543 9094 www.thepacific.net
Wairarapa
---
WIZwireless 0800 949 249 www.wizbiz.co.nz
East Coast & Hawkes Bay
---
Gisborne.net 06 867 6384 www.gisborne.net
Taylor Broadband 06 929 9082 www.taylorbroadband.co.nz
Taranaki
---
Primo Wireless 0800 123 774 www.primowireless.co.nz

Waikato & BOP
AoNet 0800 100 534 www.aonet.co.nz
Lightwire 0800 121 314 www.lightwire.co.nz
Full Flavour 0508 GO FAST www.fullflavour.nz

Northland
Uber 0508 Broadband www.uber.co.nz

Latest articles relating to internet speeds in rural NZ:

PM Bill English announces $270m investment to get rural NZ on ultra-fast broadband 28th August, 2017
The internet of Things: Wireless internet for 100+ hectare farm office 20th June, 2017
Waimate Community Wireless Trust looks to expand nationwide 10th April, 2017
Telcos pitch together for rural services 4th April, 2017
Vodafone snatches rural services firm 24th March, 2017
Satellite start-up promises ultra-fast internet to remote NZ 13th March, 2017
Rural New Zealand gets a taste of satellite broadband 13th February, 2017
South Taranaki towns to get Ultra-Fast broadband 8th February, 2017
$33M Ultra-Fast broadband rollout for Northland 27th January, 2017
Fibre internet speeds on the cards for rural regions 9th January, 2017
No more travelling for Wi-Fi 21st December, 2016
4G internet a boon for Fairlie 13th December, 2016
Chorus upgrades more rural broadband cabinets around NZ 12th December, 2016
Poorly-served rural areas promised fast internet plans 26th October, 2016
NZ Wireless rural broadband hits key milestone 19th June, 2016
RBI cell tower completion boosts rural coverage 8th June, 2016

More information

We're retiring Cashmanager RURAL Desktop
Frequently Asked Questions

Frequently asked questions

INTERNET & CONNECTIVITY

How good does my internet connection need to be?
Cashmanager RURAL has been designed to work with rural broadband. Basically, if you can log into your online banking website, or into Facebook, you'll be able to use Cashmanager RURAL online.

How secure is my data?
Your data is stored servers maintained in New Zealand to the same security standard as major banks. In some ways, it’s much safer than storing data on your PC.

Can I enter data off-line and then sync it with Cashmanager RURAL online?
Cashmanager RURAL online does require an internet connection while you’re logged into your database.

USABILITY

Do I have to learn a new system?
Cashmanager RURAL online looks and feels the same as desktop with added benefits like bank and rural supplier feeds and automatic price updates from dairy companies for the Dairy Forecaster.

Cashmanager RURAL terms of use

To read the terms and conditions for Cashmanager RURAL and Farm Focus, click here

We're retiring Cashmanager RURAL desktop

The team at CRS Software is committed to innovation.
As we pursue this goal, we’re always looking for ways to enhance the product experience, improve quality and reliability, and help farmers achieve their goals.

Since 2008, clients have changed the way they use Cashmanager RURAL, with the majority accessing it online.

We want to make sure we prioritise delivering the best possible experience to our clients, which is why we’ve decided to now focus our efforts on our online products.

Key dates you should know

As we prepare to retire the desktop version, we have supplied information that will apply to your farm subscription.

February 28, 2019
If your subscription renewal date falls on or before February 28, 2019, your final annual activation code will be supplied (dependant on your subscription renewal date).

You will not be issued a new activation code if your subscription renewal date falls after February 28, 2019.
Instead, your farm subscription will expire on the subscription renewal date and move into a Read-Only state.

You can still look at information and print reports, but you won't be able to add new or edit existing information.

February 29, 2020
Cashmanager RURAL desktop will no longer be available to use or be supported by our team.

Sign up here

To register online, click on the link above. Once you are registered, call our team on 0800 888 080 and we will take you through the next simple steps.

Your chance to win

Every month, the first 20 clients to transfer to Cashmanager RURAL online will be entered in the draw for a chance to win a $200 Farmers or Farmlands voucher.

Why move to online?

As technology progresses we, as a company are committed to keeping pace and setting the standard for innovation in farm financial software.

90% of our clients are now enjoying the benefits of being online which include:

• Automated bank feeds

• Monthly Farmlands statement feed

• Automatic price updates from major dairy companies

• Scan and attached invoices to transactions

• Your data is stored in the cloud, no more backups!

The best thing about moving to online is you're not learning a whole new system. Once you have logged into your database, the look and feel of Cashmanager online is identical to your desktop version.

Move to online simple

Read how longtime Cashmanager RURAL user Ruth Smith made the move from desktop to online and hasn’t regretted it.

Dairy farming near Sanson, in the Manawatu, Ruth has been a Cashmanager user for as long as she can remember, having been recommended the product by their accountant when they started out.

“ANZ (bank) held an event about Cashmanager and showed us the online version. I thought ‘this is the way to go’ and so we did,” she explains.
“With online you save time, everything is there and it’s simple. You download the bank statements and all you have to do is code the transactions. Basically, it’s just time-saving.”

Ruth found it simple and straightforward to switch from desktop to online and figured out how to do it herself. “I never regretted it for a moment,” she says.
“Online is quicker, easier and I’m more up-to-date with my accounts because of it. Now that I’ve discovered I can import my Farmlands statement too it’s even better – I just have to check the coding.”

More information

Internet options
Frequently asked questions

Springclean your database

To ensure the general health of your Cashmanager RURAL database, we recommend that you run a springclean at least once every GST period.

Running a springclean is also a mandatory step when closing of a previous financial year.

What does a springclean do?

Running a regular springclean helps you to identify if there is anything wrong with your database that may affect reports such as the GST report or unbalance the Accountants Annual report .

Check out our topic, How to fix Springclean errors, which identifies common errors and the recommended solutions you can try to fix them.

How to run a springclean

Go to the front screen of your database.

1. Click on Tools.
2. Select Springclean.

If, at any time you need help to fix any errors, you can contact our Help Desk:

Phone 0800 888 080
Email support@crssoftware.co.nz

Hi @hardgraft

Apologies for the delay - we've been a bit tied up at Mystery Creek.

The budget worksheet really works best as below so that the cash calculations are pulled into the cashflow.

Quantity = number of ewes (or ha for crops/fert)
Multiply by = dose per ewe (or tonnes/kg of fert, seed, kg of wool etc)
Price = cost per dose (or $/T or kg)

Variables is a tool that works in the cashflow screen to speed up data entry if you're working to this type of scenario and also allows for a change of ewe numbers or cropping area throughout the year.

Variables are located in Setup - Variables.

If you've set up variables, click on variables in a budget worksheet and select the code related to a specific variable.

If you'd like training in this area, feel free to contact the support team on 0800 888 080 and one of the team can book in a session with you.

Thanks,
Jo

Farm Focus frequently asked questions

We have put together a list of frequently asked questions about Farm Focus, the next generation of Cashmanager RURAL.

Click here to learn more about features, billing and switching to Farm Focus.

Hi @Mardi757

There are a number of payroll products out there that are tailored to meet the specific needs of agri businesses.
i.e. timesheets, rosters, allowances etc

A couple of suggestions below:
agrismart.co.nz
www.paysauce.com

Hi @mcdour

Yes, it may depend on what you have selected to view.

You may need to contact our helpdesk but in the meantime, you could check the following:

• Have you selected Revision from the Cashflow Options screen?
• Is the revision date, showing Actual data up to..., correct?

Thanks,
Jo

@forriej

Below are links to some helpful articles around importing trader statements like Farmlands, FarmSource and PGG Wrightson.

• Set up Farmlands monthly statement feed

• How to import your trader statement into a bank transaction

• Importing your trader statement (standard import)

Trends report

This page is currently being updated.

Hi @Snirtus

Thanks for your comment.

NZ GST codes do differ from AUS codes. For example, NZ clients using Cashmanager would code a financial transaction like interest to GST type E (Exempt).

I've sent your suggestion to our Development team to consider.

Thanks,
Jo

Export Cashmanager transactions for CCH iFirm

Before you start, check the following in your client's Cashmanager RURAL database:

• Bank Accounts are balanced
  Make sure all transactions are reconciled to the bank account(s).
  All transactions will be exported regardless of whether they're reconciled or not.

• Codes are aligned
  Check that your client's Cashmanager RURAL code list has been mapped to your chart of accounts.
  Any transactions that haven't got a corresponding accountants code will be allocated to a SUSPENSE code in the .csv file.

• Amounts
  Make sure there are no transaction with $0.00 in the amount. They will not import into the general ledger.

Step 1 - Export transactions out of Cashmanager

From the Transactions screen:

1. Click on the Export menu.

2. Select Accountants.

3. Set the Accountants format to Xero.

4. Select the financial year you want to export.

5. Select the folder destination and click OK.

Step 2 - Customise the Cashmanager .csv file

After you've opened the .csv file in Excel, enter the following column headers:

Column	Header
A	Date
B	Amount
C	Comment
D	CodeDescription
E	Reference
F	Code
G	TaxType
H	Tax (create New olumn)
I	TransactionQuantity

Amount
Cashmanager displays expense amounts as negative and income as positive.
Because CCH requires the opposite in the export file, you need to change the way the amounts are displayed.

1. Put -1 into a cell to the side of the transaction information.

2. Copy the cell.

3. Highlight all figures in the amount column.

4. Right-click your mouse and select Paste Special.

5. Tick multiply.

6. Click OK.

TransactionQuantity
The same applies for TransactionQuantity as for the amount so if a quantity relates to an amount, it needs to be adjusted.

Repeat steps 1-6 above so that the quantities are correctly displayed with their corresponding amount.

Tax
GST is not included in the .csv file during the initial export. It needs to be calculated and added into to Tax (column H).

1. Sort the spreadsheet by TaxType.

2. Enter the following formula into the Tax column against the first transaction line: =SUM(B2*3/23)

3. Drag the figure in the first line down the column to calculate GST for the remaining income and expense lines.

Payables and Receivables

1. Sort the spreadsheet by Date.

2. For transaction lines that have a date after balance date, change their date to reflect the last day of the income year.

Hi @carroll

Apologies for the inconvenience of the last few days.

A few of our clients have had the following error message when logging in for the first time since last Wednesday - The database file is larger than the configured maximum database size.

The article below on our HelpCentre will walk you through how to fix this error and get back into your database.

How to get into Cashmanager

If you need a hand, our team are available on:

• phone 0800 888 080 (8.45am - 7pm weekdays)

• email support@crssoftware.co.nz (48-hour turnaround)

• livechat (8.45am - 9pm weekdays)

The database file is larger than the configured maximum database size

If you see this message please follow the instructions below to get back up and running.

NOTE: These instructions also apply to Foreign Key Value and Host Synch errors.

1. Make sure Cashmanager is closed.

2. Click on the File Explorer button at the bottom of your screen.

3. Double left click on the (C:).

4. Open the folder called Users.

5. Select the folder with your name, or the name you use to log into your computer.

6. Open the folder called AppData.
   If you can't see it, click on the View menu and tick Hidden items
   You should now be able to see the AppData folder.

TIP: For Windows 7, click on Organise - Folder and Search options - the View tab. Then tick "Show hidden files, folders and drives".

7. Open the AppData folder, then the folder Local.
8. Open the CRS Software folder.

You will see a file call LocalSystemDB, a file called Report Settings and one or more files made up of a mix of letters and numbers.

9. Delete all files in this folder.

10. Close the window, log back into Cashmanager Rural Online and open each database.