Child pages
  • RetailBasics accounting export journals explained - cash accounting method (Australia only)


 

 

RetailBasics

ANSWER ID:9431

This support note outlines the debit and credit transaction postings or journals that are generated by various processes in RetailBasics. These journals are then imported into your MYOB accounting software.

In the examples listed below, all journals are shown in a tax inclusive format.  The rate of each tax code is applied to the amount shown in the Dr or Cr column, and the calculated amount is then posted to the linked account associated to the tax code. 

For example an amount of $110 appears in the DR column with a tax code of GST. This means that $100 is posted to the displayed account number and $10 (GST = 10%) is posted to the linked account for GST in your MYOB accounting software.

This support note assumes a GST rate of 10%.

TransactionDetails
Cash Sales 

To record the money received whereby the income is recognised immediately. In this example a product at a tax inclusive selling price of $220:

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

220

 

N-T

4-1100

Sales (Income)

 

220

GST

Refunds

To record the money paid when a refund has been issued. In this example a product at a tax inclusive selling price of $220:

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

 

 220

N-T

4-1100

Sales (Income)

 220

 

GST

Any discounts that are applied will reduce the amount of Sales Income accordingly.

Lay-bys

RetailManager does not treat a lay-by transaction as income until the last payment has been made and the goods have left the store, so there is no transaction recorded in the accounting program when a lay-by is created. GST is reportable on the amount of the lay-by payments when they are made.

In the event where a service fee is charged, income is recorded upon the first payment for the portion of the service fee only.

Recording a lay-by payment

The example below is an initial payment of $20 on a lay-by of $220.

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

20

 

N-T

2-1310

GST Collected (Liability)

 

20

GST

2-1310

GST Collected (Liability)

20

 

N-T

2-2200

Lay-by Payments (Liability)

 

20

N-T

Recording a lay-by payment (with a service fee)

The example below is an initial payment of $20 on a lay-by of $220, and a $5 service fee.

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

20

 

N-T

2-2200

GST Collected

 

15

GST

2-2200

GST Collected

15

 

N-T

2-2200

Lay-by Payments (Liability)

 

15

N-T

4-1100

Sales (Income) Service Fee

 

5

GST

The $5 service fee is recorded as income while the remaining $15 is treated as a lay-by payment.  The GST account is CR for $15 with GST charged and then DR for $15 with N-T, this clears the $15 from the GST collected account while allowing tax to be calculated on the payment amount only.

Recording the final lay-by payment (item collected)

The example below is the remaining payment of $200 on a lay-by of $220. The initial $20 was paid previously. 

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

205

 

N-T

2-2200

GST Collected

15

 

GST

2-2200

GST Collected

 

15

N-T

4-1100

Lay-by Payments (Liability)

220

 

N-T

2-1320

Lay-by Payments (Liability)

 

205

N-T

4-1100

Sales (Income)

 

220

GST

Cancelling a lay-by

The example below is an initial payment of $20 on a lay-by of $220. This amount has been cancelled, and a $20 refund has been issued.

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

20

 

N-T

2-2200

GST Collected

 

20

GST

2-2200

GST Collected

20

 

N-T

2-2200

Lay-by Payments (Liability)

 

20

N-T

Cancelling a lay-by (with a service/cancellation fee)

The example below is an initial payment of $50 on a lay-by of $220. This amount has been cancelled, and a $35 refund has been issued. There was a $5 service fee, and a $10 cancellation fee.

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

 

 35

N-T

4-1100

Sales (Income)

 

 10

GST

2-2200

GST Collected

 45

 

GST

2-2200

GST Collected

 

 45

N-T

2-2200

Lay-by Refund (Liability)

 45

 

N-T

2-2200

Lay-by Refund (Liability)

 5

 

GST

4-1100

Sales (Income) Service Fee

 

 5

GST

Cash Till Shortage 

Assuming total cash sales of $220 for the day, when the cash till takings were actually $100 with a shortfall of $120. To record the expenses incurred for a till shortage:

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

220

 

N-T

1-1100

Bank Account (Asset)

 

120

N-T

6-1000

Till Shortage

120

 

N-T

4-1100

Sales (Income)

 

220

GST

Cash Till Excess 

Assuming total cash sales of $220 for the day, where the cash till takings were actually $300. (Was in excess by $80) To record the income received for the extra money found:

Acc #

Account Name

Dr

Cr

Tax Code

1-1100

Bank Account (Asset)

80

 

N-T

6-1000

Till Shortage

 

80

N-T

1-1100

Bank Account (Asset)

220

 

N-T

4-1100

Sales (Income)

 

220

GST

When the cash drawer is short, the shortfall is debited to the Till Shortage expense account. When the cash drawer is short, the shortfall is debited to the Till Shortage expense account. Alternately when the cash drawer is in excess, this excess is posted as a credit to the same Till Shortage account as a negative expense.