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:

Receipt Details
Card Identification
Allocation Line Fields

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.
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