Arise Software Ltd

Support and Help Docs

2. April 2019 12:41
by Admin
0 Comments

Large Database Size

2. April 2019 12:41 by Admin | 0 Comments

Microsoft records all activity in the LDF file and can get large. The activities can be removed although we then cannot do database audit forensics on it later, if ever required. To empty the LDF file via sql server management studio, query analyser

USE master

ALTER DATABASE gdpro SET RECOVERY SIMPLE WITH NO_WAIT

use gdpro

DBCC SHRINKFILE(gdpro_log, 1)

USE master

ALTER DATABASE gdpro SET RECOVERY FULL WITH NO_WAIT

2. April 2019 11:52
by Admin
0 Comments

Rounding Transactions

2. April 2019 11:52 by Admin | 0 Comments

Old GDPro used 4 decimal places for financial transactions when going things like successions and distributions. New GDMA automatically rounds transactions to 2 decimal places.

Avoid distributions and successions in GDPro and do them in GDMA. To round financial transactions to 2 decimal places:

In gdma go to options

 

Then Round…

7. March 2019 16:14
by Admin
0 Comments

Custom fields on main screen

7. March 2019 16:14 by Admin | 0 Comments

Custom fields that use to be in the Misc tab are now on the main screen. If they have not been used prior, the screen will look similar to this:

To update the captions, go to Misc tab

Click Update Text

Update the captions:

Restart GDPro/GDMA and they will now show with the updated captions

 

 

 

20. February 2019 15:20
by Admin
0 Comments

BNZ International DC Payments

20. February 2019 15:20 by Admin | 0 Comments

An option to pay overseas via BNZ International Direct Credit online banking, is available via the normal payment system called BNZ Intl.

BNZ requires:

  • Owner Name
  • Owner Address (requires 2 address lines and no PO Box or Private Bag)
  • Owner Bank Account
  • Owner Country code.
  • Bank Country code.
    • This is the country of the owner’s bank and would typically be the same as owner country code.
  • Owner Bank BIC Swift Code, if country code is not AU
    • Refer to note below.
  • Correspondent Bank Fee Indicator.
    • This is either B or O. B = beneficiary(owner) pays fee or O = the trust pays fee
  • Owner Bank Clearing Code.
    • Refer to note below.

Owner Bank BIC Swift Code and Owner Bank Clearing Code. This information is obtained from the owner and is key to the BNZ international payment system. There is no automated way we can get this info and must be entered manually once obtained by the owner, into GDPro’s/GDMA’s bank account details field for each owner that requires a BNZ International Direct Credit payment.

If the country code is AU then only the Owner Bank Clearing Code is required and not the Owner Bank BIC Swift Code.

Please refer to https://www.bnz.co.nz/assets/business-banking-help-support/internet-banking/ib4b-file-format-guide.pdf?v=3 page 28 and discuss with BNZ.

 

The format of the BNZ requirement that is to be entered in GDPro’s/GDMA’s bank account details field is as follows:

PT*<Owner Country Code, 2 characters>*<Bank Country Code, 2 characters>*<Owner Bank BIC Swift Code, 11 characters>*<Correspondent Bank Fee Indicator, 1 character>*<Owner Bank Clearing Code, 15 characters>

 

This is an example that is entered into the bank account details field: PT*AU*AU**O*AU123456

The above states that a payment is to be made to an <Owner Country Code> AU, <Bank Country Code> AU, <Owner Bank BIC Swift Code> (there is no BIC Swift Code as the country code is AU), <Correspondent Bank Fee Indicator> O the trust pays the international payment fee and <Owner Bank Clearing Code> is AU123456

 

Although a bit complex, these are the requirements from BNZ as stipulated here https://www.bnz.co.nz/assets/business-banking-help-support/internet-banking/ib4b-file-format-guide.pdf?v=3 from page 19.

 

Creating the file is the same as creating the current BNZ file for local NZ payments - by selecting bank option BNZ Intl - although the steps to import into BNZ online banking will be slightly different. The best people to talk about how this is done is your BNZ manager(s).

1. November 2018 11:32
by Admin
0 Comments

Excel Bank Accounts Numbers

1. November 2018 11:32 by Admin | 0 Comments

Excel will remove zeros at the beginning of bank accounts, when opening a CSV file. If opening the file in notepad, it can be seen the bank # are intact. Best attempt to get it opening in Excel as follows:

Open file in notepad, click Edit then Replace

Find ,”0 (that is comma | double quote | zero) and replace with ,””0 (that is comma | double quote | double quote | zero)

Open file in Excel and select the bank account column by clicking on the column header to select the entire column

Right click, select Format Cells

Select Custom, then Type to be 0, click OK

It will not be perfect but at least the full account number can be seen.

30. October 2018 11:38
by Admin
0 Comments

Cannot open payment system

30. October 2018 11:38 by Admin | 0 Comments

If you can an error message saying the date is in the incorrect format, or similar, when attempting to open the payment systems, please try the following:

Go here:

Click Statement

Update both dates to today's date using [*] buttons, ensuring to press the Tab key after each change

Retry the payment screen.

 

 

17. October 2018 11:56
by Admin
0 Comments

Custom Statement

17. October 2018 11:56 by Admin | 0 Comments

To create your own custom statement:

Export the statement list:

Open the exported file and format the columns E,G,H,I,J,K:

Use the file to mail merge with the attached MS Word document.

1.csv (347.00 bytes)

CustomStatement.docx (24.37 kb)

How to mail merge: https://www.google.com/search?q=how+to+mail+merge+with+ms+word

Format the document to suit. For windows envelopes, adjust the top placement of the name/address until it fits inside the window.

 

 

17. October 2018 10:48
by Admin
0 Comments

Maori Authority Credit MAC Calculation

17. October 2018 10:48 by Admin | 0 Comments

Maori Authority Credits are just like Company Dividend Input Credits, so the Gross amount is payable to the tax payer (shareholder) less the Maori Authority tax which is 17.5%, that is paid to the IRD.

Refer to IRD Reference regarding MAC

The following can be used to assist in MAC calculation

MAC Calc June 2018.xlsx (11.68 kb)

Rates on the distribution screen

The above will tax at 33% (17.5% + 15.5%) for those with no IRD and more than $200 in distribution. If there is no threshold (i.e. $200) then change the RWT Threshold to $0.

For the system to apply NRWT, the NRWT needs to be ticked against each owner on the main screen. It is an IRD requirement for the owner to supply NRWT certificate to be eligible.

It is assumed there is enough Maori Authority credits. If it is not known, IRD will need to be contacted.

RWT

Regarding RWT on entire distribution and not just those paid out "A Māori authority declares a distribution for all beneficiaries, calculating the payout and crediting the account of each beneficiary. They make payment to known beneficiaries but some distributions remain unclaimed. The Māori authority is required to account for RWT on the full amount declared not just the amount physically paid to beneficiaries"

https://www.ird.govt.nz/resources/9/e/9e39965e-b940-432e-a183-e6f7486e5a48/ir1027.pdf

https://www.ird.govt.nz/maori-organisations/introduction/intro-maori-authorities/maoriauthorities-intro-maori-authorities.html

https://www.ird.govt.nz/maori-organisations/credits/credit-rules/maori-authorities-credits-allocation-rules.html

Threshold Net of Distribution

To have the threshold net of distribution – that is the distribution less MA credit % - changing the threshold to be $242.42. That is $200 + Maori Authority Credit of 17.5% inclusive. It seems confusing at first the calculation ($200 x 21.21%) but it is calculated as an imputation credit. That is if you apply 17.5% to the $242.42, you will get the MA Credit of $42.42.

https://www.ird.govt.nz/maori-organisations/credits/credit-rules/

Opinion on NRWT

Individuals living overseas have the same rates apply as if they were residents unless they have provided you with an IRD supplied NRWT certificate. NRWT if ticked will only apply 15%, regardless.

https://www.ird.govt.nz/resources/d/0/d0ddc344-5405-44cc-aa98-e04584e47d40/ir291.pdf