Knowby Sculptform
Knowby
Customer Deposit/Payment Process - Salesforce, & MYOB (AU & NZ)
Purpose: To allocate payments in Salesforce and MYOB and let the Sales/CHT know the payments we received yesterday.
Purpose: To allocate payments in Salesforce and MYOB and let the Sales/CHT know the payments we received yesterday.
1
Step 1 of 20
<p>Every morning, we send the deposit list to the group ASAP and include the BOQ/SO/INV # paid. Watch for multiple invoice/BOQ being paid in one payment.</p><p>3 types of payment we receive </p><ul><li><p>Deposit for BOQ/Quotes/SO (33% Normally) </p></li><li><p>Balance for SO </p></li><li><p>Balance for INV (Debtor)</p></li></ul><p></p>

Every morning, we send the deposit list to the group ASAP and include the BOQ/SO/INV # paid. Watch for multiple invoice/BOQ being paid in one payment.

3 types of payment we receive

  • Deposit for BOQ/Quotes/SO (33% Normally)

  • Balance for SO

  • Balance for INV (Debtor)

2
Step 2 of 20
<p>Spreadsheet link - https://wfarch.sharepoint.com/:x:/s/OperationsTeam/ETljtlKnlEVYl0axQ6jF26QBssY0vj3YFfc0X-wp6jXZsQ?e=8Z2229
*If customer forgot to send remittance/put BOQ/SO/INV # on the payment search the Company in SF https://sculptform.lightning.force.com/lightning/page/home</p>

Spreadsheet link - https://wfarch.sharepoint.com/:x:/s/OperationsTeam/ETljtlKnlEVYl0axQ6jF26QBssY0vj3YFfc0X-wp6jXZsQ?e=8Z2229 *If customer forgot to send remittance/put BOQ/SO/INV # on the payment search the Company in SF https://sculptform.lightning.force.com/lightning/page/home

3
Step 3 of 20
<p>#1
Deposit Received for BOQ/Quote.
Which means in the Salesforce the BOQ has not been converted to SO. In this case we cannot apply the payment in SF.</p>

#1 Deposit Received for BOQ/Quote. Which means in the Salesforce the BOQ has not been converted to SO. In this case we cannot apply the payment in SF.

4
Step 4 of 20
<p>It is the responsibility of the Estimation/Sales team to apply the payment when they convert the BOQ to SO in Salesforce. Accounts need to put the payment date on BOQ.</p>

It is the responsibility of the Estimation/Sales team to apply the payment when they convert the BOQ to SO in Salesforce. Accounts need to put the payment date on BOQ.

5
Step 5 of 20
<p>Record as a receive money in MYOB (2-8832 Salesforce-Customer Deposits)
•	Change the Memo note to what is on the spreadsheet.
•	In the Acct No, select the 2-8832 account</p>

Record as a receive money in MYOB (2-8832 Salesforce-Customer Deposits) • Change the Memo note to what is on the spreadsheet. • In the Acct No, select the 2-8832 account

6
Step 6 of 20
<p>#2 Deposit (normally 33%) or Balance payment (from prepaid customer) for SO. BOQ has been converted to SO, but INV has not been done. In this case we must apply the payment to SO in SF in the Financial info Section. *SO and INV number are the same in SF. Only difference (INV- and SO-)</p>

#2 Deposit (normally 33%) or Balance payment (from prepaid customer) for SO. BOQ has been converted to SO, but INV has not been done. In this case we must apply the payment to SO in SF in the Financial info Section. *SO and INV number are the same in SF. Only difference (INV- and SO-)

7
Step 7 of 20
<p>Match the balance due and payment received then apply the payment.
•	If payment is fully received change Payment status to YES.
•	Put payment date
•	Add paid figure to paid to date figure that is already paid. E.g. (25,877.97+52,540.13)
•	Click Save
In MYOB follow Step 5.</p>

Match the balance due and payment received then apply the payment. • If payment is fully received change Payment status to YES. • Put payment date • Add paid figure to paid to date figure that is already paid. E.g. (25,877.97+52,540.13) • Click Save In MYOB follow Step 5.

8
Step 8 of 20
<p>#3
Payment for INV/Debtor.
In SF the BOQ has been converted to SO and INV has been issued.
The INV is normally issued when the goods are ready to be or have been despatched
We must apply the payment in both SO &amp; INV in SF, this is from account customer/Debtor or prepaid.</p>

#3 Payment for INV/Debtor. In SF the BOQ has been converted to SO and INV has been issued. The INV is normally issued when the goods are ready to be or have been despatched We must apply the payment in both SO & INV in SF, this is from account customer/Debtor or prepaid.

9
Step 9 of 20
<p>•	Apply payment in SO first as per Step 7.</p>
<p>•	Open INV from SO &gt; click receive payment.</p>
<p>•	Check the amount we have received and change if needed, also change the receipt date and click save.</p>
<p>•	In MYOB – Records as a receive payment – Choose Customer – apply payment.</p>

• Apply payment in SO first as per Step 7.

• Open INV from SO > click receive payment.

• Check the amount we have received and change if needed, also change the receipt date and click save.

• In MYOB – Records as a receive payment – Choose Customer – apply payment.

10
Step 10 of 20
<h3><strong>Direct Deposit Processing – SFM AU (MYOB)</strong></h3><p></p><p><strong>SFM AU will receive payments from Loan – US, UK, and NZ.</strong></p><p></p><p><strong>All regions follow the same process apart from SFM USA, which includes bank fees that need to be journaled.</strong></p><p></p><p><strong>For this example, the payment is from SFM NZ.</strong></p><p></p><p></p>

Direct Deposit Processing – SFM AU (MYOB)

SFM AU will receive payments from Loan – US, UK, and NZ.

All regions follow the same process apart from SFM USA, which includes bank fees that need to be journaled.

For this example, the payment is from SFM NZ.

11
Step 11 of 20
<h3><strong>Direct Deposit Processing – SFM AU (MYOB)</strong></h3><p></p><p><strong>For payments coming from Loan‑NZ, US &amp; UK, they will appear in MYOB.</strong></p><p><strong>Then click:</strong></p><p><strong>&gt;&gt;New</strong></p><p><strong>&gt;&gt;Received Money</strong></p>

Direct Deposit Processing – SFM AU (MYOB)

For payments coming from Loan‑NZ, US & UK, they will appear in MYOB.

Then click:

>>New

>>Received Money

12
Step 12 of 20
<p>At <strong>Receive Money:</strong></p><p></p><p>-<strong>Date </strong>must match the date payment appears in the bank feed.</p><p>-Choose the <strong>Account Number where the payment came from</strong> — in this case, it is SFM NZ.</p><p></p><p><strong>Loan Account Numbers</strong></p><p>NZ: 1‑6625</p><p>USA: 1‑6630</p><p>UK: 1‑6631</p>

At Receive Money:

-Date must match the date payment appears in the bank feed.

-Choose the Account Number where the payment came from — in this case, it is SFM NZ.

Loan Account Numbers

NZ: 1‑6625

USA: 1‑6630

UK: 1‑6631

13
Step 13 of 20
<p><strong>At the Loan – US, UK, NZ &amp; Global file:</strong></p><p><br>Update and reflect the payment made and the remaining balance outstanding.</p>

At the Loan – US, UK, NZ & Global file:


Update and reflect the payment made and the remaining balance outstanding.

14
Step 14 of 20
<p>As shown in the example, there is a credit note (SFM‑Rework ‑$37,779.13) in the statement file. This must be applied first before applying the payment received from SFM NZ.</p><p></p><p>Go To Dashboard:<br>&gt;&gt;Sales<br>&gt;&gt;Sales Register<br></p><p>Then search and choose, either:</p><ul><li><p>Sculptform NZ</p></li><li><p>Sculptform UK</p></li><li><p>Sculptform USA LLC<br></p></li></ul><p>&gt;&gt;Returns &amp; Credits<br>&gt;&gt;Apply to Sale<br><br>&gt;&gt;Date<br>&gt;&gt;Applied Amount<br>&gt;&gt;Record</p><p></p><p></p>

As shown in the example, there is a credit note (SFM‑Rework ‑$37,779.13) in the statement file. This must be applied first before applying the payment received from SFM NZ.

Go To Dashboard:
>>Sales
>>Sales Register

Then search and choose, either:

  • Sculptform NZ

  • Sculptform UK

  • Sculptform USA LLC

>>Returns & Credits
>>Apply to Sale

>>Date
>>Applied Amount
>>Record

15
Step 15 of 20
<p></p><h3><strong>Compare &amp; Match the MYOB Invoices</strong></h3><p><strong>To reconcile</strong>, go to <strong>Dashboard</strong>:</p><ol><li><p><strong>Banking</strong></p></li><li><p><strong>Reconcile Accounts</strong></p></li></ol><p>Then:</p><ul><li><p>Select the <strong>Account#</strong> (NZ, US, or UK).</p></li><li><p><strong>Closing Statement Balance:</strong> <code>0.00</code></p></li><li><p><strong>Bank Statement Date:</strong> <em>Today</em></p></li></ul><ul><li><p>Tick only the <strong>MYOB transactions</strong> that have been paid as per the statement.</p></li><li><p>The screen will show the <strong>Cleared Amount</strong> (below) and the <strong>Out of Balance</strong> amount (above).</p></li><li><p>At this point, the <strong>Out of Balance</strong> amount should correspond to the <strong>SFM invoices</strong> in the statement (&amp; bank fees for US).</p></li><li><p>Always review and ensure everything matches the MYOB &amp; Statement file.</p></li></ul><p>Then go back to the Dashboard to enter the payment for the SFM invoices.</p><p></p>

Compare & Match the MYOB Invoices

To reconcile, go to Dashboard:

  1. Banking

  2. Reconcile Accounts

Then:

  • Select the Account# (NZ, US, or UK).

  • Closing Statement Balance: 0.00

  • Bank Statement Date: Today

  • Tick only the MYOB transactions that have been paid as per the statement.

  • The screen will show the Cleared Amount (below) and the Out of Balance amount (above).

  • At this point, the Out of Balance amount should correspond to the SFM invoices in the statement (& bank fees for US).

  • Always review and ensure everything matches the MYOB & Statement file.

Then go back to the Dashboard to enter the payment for the SFM invoices.

16
Step 16 of 20
<h3><strong>To Apply the Payment for SFM Invoices</strong></h3><p>Go to <strong>Dashboard</strong>:</p><p><strong>&gt;&gt;Sales</strong></p><p><strong>&gt;&gt;Sales Register</strong></p><p><strong>&gt;&gt;Received Payments</strong></p><p></p><h3><strong>Select the Correct Loan Account</strong></h3><p>Under <strong>Deposit to Account</strong>, choose the corresponding loan account:</p><ul><li><p><strong>NZ:</strong> 1‑6625</p></li><li><p><strong>USA:</strong> 1‑6630</p></li><li><p><strong>UK:</strong> 1‑6631</p></li></ul><h3><strong>Select the Customer</strong></h3><p>Choose the correct customer based on the region:</p><ul><li><p><strong>Sculptform NZ</strong></p></li><li><p><strong>Sculptform UK</strong></p></li><li><p><strong>Sculptform USA LLC</strong></p></li></ul><p><strong>Date:</strong> Must match the date the payment appears in the <strong>bank feed</strong>.</p><p></p><p><strong>Amount Received:</strong> Enter the <strong>total</strong> of the</p><p>SFM invoices that have been paid.</p><p></p><p>Then go to:</p><p><strong>Amount Applied</strong></p><p></p><p><strong>&gt;&gt;Record</strong></p><p></p><p></p><p>This transaction will go through the Loan Account reconciliation.</p>

To Apply the Payment for SFM Invoices

Go to Dashboard:

>>Sales

>>Sales Register

>>Received Payments

Select the Correct Loan Account

Under Deposit to Account, choose the corresponding loan account:

  • NZ: 1‑6625

  • USA: 1‑6630

  • UK: 1‑6631

Select the Customer

Choose the correct customer based on the region:

  • Sculptform NZ

  • Sculptform UK

  • Sculptform USA LLC

Date: Must match the date the payment appears in the bank feed.

Amount Received: Enter the total of the

SFM invoices that have been paid.

Then go to:

Amount Applied

>>Record

This transaction will go through the Loan Account reconciliation.

17
Step 17 of 20
<p>To Complete the Reconciliation:</p><p></p><p>Return to the <strong>Reconcile Accounts</strong> window.</p><p></p><ul><li><p>Tick all transactions involved in the reconciliation.</p></li><li><p>Verify the Cleared Amount to ensure it is correct.</p></li><li><p>Confirm that the Out of Balance amount shows 0.00.</p></li></ul><p>Once everything matches, click <strong>Reconcile </strong>to complete the process.</p>

To Complete the Reconciliation:

Return to the Reconcile Accounts window.

  • Tick all transactions involved in the reconciliation.

  • Verify the Cleared Amount to ensure it is correct.

  • Confirm that the Out of Balance amount shows 0.00.

Once everything matches, click Reconcile to complete the process.

18
Step 18 of 20
<p>Example: SFM USA LLC with Bank Fees and Short Payment reconciliation.</p><p></p><p>SFM USA LLC typically incurs <strong>bank fee deductions</strong> on every incoming payment.&nbsp;</p>

Example: SFM USA LLC with Bank Fees and Short Payment reconciliation.

SFM USA LLC typically incurs bank fee deductions on every incoming payment. 

19
Step 19 of 20
<h3><strong>To Journal the Bank Fee</strong></h3><p></p><p><strong>Go to the Dashboard</strong></p><p><strong>&gt;&gt;Accounts</strong></p><p><strong>&gt;&gt;Record Journal Entry</strong></p><p></p><p><strong>Date must match the date the payment appears in the bank feed</strong>.<br></p><p><strong>Debit: 6‑7017 Bank Fees</strong><br><strong>Credit: 1‑6630 Loan SFM USA LLC</strong></p><p></p><p><strong>&gt;&gt;OK</strong><br></p><p></p>

To Journal the Bank Fee

Go to the Dashboard

>>Accounts

>>Record Journal Entry

Date must match the date the payment appears in the bank feed.

Debit: 6‑7017 Bank Fees
Credit: 1‑6630 Loan SFM USA LLC

>>OK

20
Step 20 of 20
<h3><strong>To Journal Short payment</strong></h3><p></p><p><strong>Go to the Dashboard</strong></p><p><strong>&gt;&gt;Accounts</strong></p><p><strong>&gt;&gt;Record Journal Entry</strong></p><p></p><p><strong>Date must match the date the payment appears in the bank feed</strong>.</p><p></p><p><strong>Debit: 4-9999 Currebcy Gain/Loss(as per Ken)</strong><br><strong>Credit:&nbsp;</strong>choose the corresponding loan account</p><ul><li><p><strong>NZ:</strong> 1‑6625</p></li><li><p><strong>USA:</strong> 1‑6630</p></li><li><p><strong>UK:</strong> 1‑6631</p></li></ul><p><strong>&gt;&gt;OK</strong></p>

To Journal Short payment

Go to the Dashboard

>>Accounts

>>Record Journal Entry

Date must match the date the payment appears in the bank feed.

Debit: 4-9999 Currebcy Gain/Loss(as per Ken)
Credit: choose the corresponding loan account

  • NZ: 1‑6625

  • USA: 1‑6630

  • UK: 1‑6631

>>OK