TransPost Help

Receive Money Fields

The Receive Money import type imports Receive Money transactions. The fields correspond to fields on the AccountRight Receive Money form.

Receive Money transactions can only be imported using TransPost Plus and TransPost Premier.

There are groups of fields dealing with:

The grey fields are only shown when the All fields radio button is selected. They are all optional and less often used.

Receipt details
ReceiptNumber
Transaction number or cheque number used to identify the Receipt. If omitted MYOB will generate one.
ReceiptDate
Receipt date. If omitted defaults to the current date.

This will be interpreted based on your regional date format, i.e. in Australia, NZ something like d/m/yy or dd-mm-yyyy or similar. Time if present will be ignored. Texts Yesterday or Today or Tomorrow will be interpreted appropriately which can be handy as a default.

Action
Single character code indicating what action is to be applied. The only action code applicable to Receive Money transactions is D to delete.

When deleting, the ReceiptNumber (transaction Id No.) and/or Receipt Date are required to uniquely identify the receipt to delete. other details are ignored.

DepositAccount
Deposit to Account, i.e. the account code for the bank account in MYOB.
UseUndepositedFunds
Use Undeposited Funds - Select by inputting or setting default X to Y to post the payment to Undeposited Funds.
Inclusive
Pay from Account, i.e. the account code for the bank account in MYOB.

Card Identification
The payment may come from someone represented by a card of any kind, may be selected from the available cards in MYOB. Optional but if not provided it pays to record some detail in the memo fields.
Card
The following fields may be used to identify a card as payor associated with this payment:
CardID
If the requisite cards have CardIDs this is recommended as the reliable way of identifying the correct card. If supplied this will be used and other card identification fields will be ignored.
CoLastName
If a CardID is not available then cards may be identified by name. If the data contains both company names and personal last names, in different columns you should use the CompanyName and LastName fields instead. Even when the card name is in the same column you can map it to both CompanyName and LastName.
CompanyName
Name of the card if not an individual. Use this instead of CoLastName if card organisation names and personal last names are in different input columns.
LastName
Last name of the card if an individual. Use this instead of CoLastName if card organisation names and personal last names are in different input columns.
FirstName
If the card is an individual their first name is also required to identify them.

If there are multiple cards with same name, e.g. John Smith, TransPost will use the following fields to select the right one. If only one card is identified by name then these fields are ignored.

ABN
ABN may be used to identify a specific card where there is more than one with the same name.
Email
Used to disambiguate by matching against Email associated with any of the addresses. This is a particularly useful identifier as it is unique and generally defined consistently.
Phone
May be used to discriminate between cards of the same name. Matched with phone numbers associated with any of the addresses associated with the card.
City
May be used to discriminate between cards of the same name.
State
May be used to discriminate between cards of the same name.
PostCode
May be used to discriminate between cards of the same name.
Country
May be used to discriminate between cards of the same name.
TotalAmount
Amount - Total received, optional. If omitted defaults to the total of the Amounts for each line. If supplied used to verify that those amounts add up correctly.
PaymentMethod
Payment Method. If supplied should be a valid payment method in MYOB.
Memo
Memo. This corresponds to the Memo shown on the MYOB form above the details, not to be confused with the Memo field on the payment allocation lines, which is called AllocationMemo in TransPost.

Note that the memo can be assembled from up to 5 input fields providing the option to record Payor information when the Payor is not in MYOB as a card.

Memo2, Memo3, Memo4, Memo5
These will be concatenated with Memo. They are provided so that Memo can be constructed from multiple input fields.

Payment Allocation Line Details
In the Mapping Details form, Line Details are highlighted to distinguish them from other Receive Money data fields that can only have a single value per transaction.
AllocationAccount
Account (Acct No.) - the account to which the amount is allocated
Amount
Amount allocated on the line to. tax-inclusive if TaxInclusive selected (Inclusive set to X or Y), tax-exclusive otherwise.
AllocationMemo
Memo - specific to the detail line.
Job
Job number applicable to the line. Must match a valid active detail job number in MYOB.
TaxCode
Tax code as defined in MYOB. e.g. GST or FRE.

This can also be a choice of tax codes e.g. GST or FRE in which case TransPost will check TaxAmount and apply the first tax code, GST in the example, if it is non-zero and use the second, FRE in the example, if it is zero.

TaxAmount
The amount of tax for the item. Since AccountRight will calculate the tax based on the tax code the only purpose this serves is to decide which tax code to use when the tax code has been specified as a choice, e.g.GST or FRE. The first tax code applies unless the tax amount is zero, in which case the alternative is used.
AlreadyPrinted
Cheque already printed.
DeliveryStatus
Remittance Advice Delivery STatus. You can set a default in TransPost or let it take the MYOB default. The options are:
  • P - To be Printed
  • E - To be Emailed
  • B - To be Printed and Emailed
  • A - Already Printed or Sent
Category
Category is optional. Categories not already on the AccountRight Categories List will be ignored, with a warning, as MYOB's API does not permit adding to the category list on the fly.
GroupLikeMyobImport
If GroupLikeMyobImport is set to Y TransPost will take the values on the first line of the transaction and ignore changes in any of these fields until it finds a complete blank line.