fbpx Bank Receipt | Automi Accounting

Bank Receipt

Bank Receipt

Creating Bank Receipt

When receiving payment, user can create Bank Receipts to track the transaction. Go to Banking > Bank Receipt, click New.

Select the date (which should match the bank statement date), select the Bank (in this case, a RMB Bank with System  Default Currency as HKD in this case) and enter the received Total Amount. If the payment is from a customer, select the customer from the Card field.

AutoMi has one of the most flexible banking function in the market, you can apply receipt to invoices, deductions, incomes and expenses in one screen.

After selected the Customer, click the Apply Invoice button to apply the Receipt to invoices

apply invoice

 A pop up window will be shown displaying all the outstanding invoices from the customer, select the lines to be applied to this Receipt. In this case select a HKD invoice and a USD invoice to apply.

  • Notice invoices of different Currencis are displayed for select, you can select any invoices of any currency, independent of the currency of the receiving Bank

O Sales Invoice  8] Enter text to search...  Due Date  4/5/19  4/5/19  Date  4/4/1 g  Auto Number  Sl-oooooool  Sl-oooooon  Currency  Paid A...  Total  $0.00 $1,030.00  $0.00 $450.00

If there is adjustment of apply amount needed for the invoice, for example, customer round-off the amount and not paying the round-off amount, user can enter the adjustment amount. In this case, the customer is not paying the $30 of the $1,030 but user need to offset that amount as paid.

  • The Applied Amount Original Currency (actually received) is set as $1,000, as customer did not pay the last $30
  • Adjustment Type selected Bad Debt, user can select any other adjustment type of Expense, Other Expense or Cost, the Deduction Amount set as $30
  • The Total Offset is automatically updated as the full amount $ 1,030, the invoice status will be updated as Paid afterward
  • User can add Description to remark the adjustment or other information

Original Amount  $250,380  Outstanding Amount O... Applied Amount Original  Adjustment Type  Bad Debt  Deduction Amou... Total Offset Amount Original Curr...  $0  $250,300  $80  $250,380  Description  round-off becomes bad debt uncollectable

Similarly to apply any outstanding Deductions, click the Apply Deduction

apply deduction

Select the deductions to apply, click OK.

0  Sales Deduction  8] Enter text to search...  Date  4/4/1 g  Sales Deduction Nu  sc-oooooool  Currency  Exchange Rate  1.125000  Total  $50.00  Deducted Am...  $0.00

The invoices and deduction, disregard of their currency, will be exchanged to the Bank Currency using the transaction's  Exchange Rate. User can review the breakdown of amount of the Receipt

+ Total Invoice Lines Amount:  - Total Deduction Lines Amount:  $8

If there are other Income or Expense, user can add as Income Lines or Expense Lines. For example, the customer pay extra bonus of $50 RMB to us. Click Income Lines and add a new line as follow:

  • Select Discount Rebate Taken as Adjustment Type, or other type as needed

Adjustment Type  Discount Rebate Taken  Original Currency  Applied Amount Original  $50.00  Description  Customer bonus

There is also a bank charges of $25 deducted by the bank that is paid by us. Click Expense Lines and add the line as follow:

Adjustment Type  I Bank Charges  Original Currency  Applied Amount Origi...  $25.00

Review the breakdown of the Receipt (in RMB bank currency)

+ Total Invoice Lines Amount:  - Total Deduction Lines Amount:  + Total Income Lines Amount:  - Total Expense Lines We Paid Amount:  - Receipt Total = Dfference Amount:  $4,000.09  $50.00  $50.00  $25.00  ($20.09)

As there is still a Difference with your bank statement amount, the difference will be the exchange rate gain or loss as we are exchanging the various currencies amount to RMB. User can add that by using an income or expense line, this our case:

Invoice Lines  x  Deduction Lines  Diagnostic  Income Lines  Original Currency  RM8  Expense Lines  Document C  Adjustment Type  Bank Charges  I Currency Exchange Loss  Applied Amount Origi... Descr  $25.00  $20.09

The Difference is now balanced, click Save.

+ Total Invoice Lines Amount:  - Total Deduction Lines Amount:  + Total Income Lines Amount:  - Total Expense Lines We Paid Amount:  - Receipt Total = Dfference Amount:  $4,000.09  $50.00  $50.00  $45. og  $0.00

Breakdown of a Receipt

To conclude we could breakdown the Receipt Amount into:

  1. Invoices: increase the Receipt Amount
  2. Deductions: decrease the Receipt Amount
  3. Income Lines: increase the Receipt Amount
  4. Expense Lines: decrease the Receipt Amount

Status Updates

2 customer invoices were paid in full, the system will colour-coded them as GREEN in the Sales Invoice ListView

Date  4/4/1 g  4/4/1 g  Auto Number  Sl-oooooool  Sl-oooooon

Similarly the Deduction was settled in full and colour-coded as GREEN

Date  14/1 g  Auto Number  sc-oooooool

Go to Banking > Bank Register Line, a new deposite line was added

Number  4/4/1 g  Source Transaction  8+00000001  Type  Bank receipt  Card  Line Amount  Walkin Customer __  $3,955.00  Balance Amount Per System 8,  $3,955.00