company logo

Help center

Go to Juan Accounting
All collectionsInvoicesInvoice PaymentsBulk and Batch Invoice Payments

Bulk and Batch Invoice Payments

Record invoice payments in 1 go for multiple invoices.

Q1. Can I record payments for multiple invoices at once?

  • Yes, use the Bulk Payment or Batch Payment features on Juan to record payments for multiple invoices in 1 go.

  • Select the desired balance due invoices to use the bulk or batch payment.

Q2: Can I make bulk/batch payments for invoices in different currencies?

  • Yes, you can select and pay invoices in various currencies simultaneously. 

  • All the payments will be recorded in the selected payment account currency.

Q3. What is the difference between Bulk Payments and Batch Payments?

Bulk and Batch Payments both create a separate payment for each transaction and support partial, split, and cross-currency amounts. They only differ in bank reconciliation:

  • Bulk Payments: Each payment appears as a separate cashflow record

  • Batch Payments: Payments in the batch are aggregated into a single cashflow record

Q4. Can I partially pay invoices during bulk/batch payments?

  • Yes, you can do partial payments during bulk/batch payments, by updating the invoice payment amount.

Q5. Payments created from the bulk/batch payment flow are created in which currency? 

  • The payment currency will depend on the selected payment account's currency. 

  • So, irrespective of the selected invoice currencies, all the payment currencies will be the same as the payment account currency.

Q6. Is there a way to autofill the cash received equivalent to the invoice payment amount during bulk/batch payment?

  • Yes, use the bulk/batch auto-fill feature to calculate the cash equivalent of the invoice payment amounts to the payment amounts in the payment accounts currency. 

  • Alternatively, you can autofill the cash equivalent for each payment record 

  • You can also set a custom rate for just a single payment record.

Q7. Can I add transaction fees while bulk/batch payments?

  • Yes, like the normal payments flow you can add transaction fees during bulk/batch payment creation flow. Refer to transaction fee for more info.

Q8. Is RGL calculated during bulk/batch payments? 

  • Yes, like the normal payments flow if a payment is recorded in non-base currency, RGL can occur.Refer to When does realized FX gain-loss (RGL) happen, and how is it calculated?

Q9. Is there a limit to the number of invoices I can pay at once?

  • Yes, you can only select records on a single page. If the page size is set to 200, you can select up to 200 invoices to create bulk payments. The current maximum page size is 500 records.

Q10. Can I record overpayments from the invoice bulk/batch payment flow?

  • No, you cannot record overpayments. Juan will prevent you from entering a payment amount that is greater than the balance due on the invoice.

Q11. How do I edit a recorded bulk/batch payment?

  • Find the payment record (either from the payments tab / find the invoice against which the payment is recorded) and edit the details as needed.

Q12. Why are there separate columns for "Payment" and "Cash Received"?

  • The "Payment" column reflects the invoice's original amount due in its designated currency. 

  • The "Cash Received" column allows you to record the actual amount received, which might differ due to exchange rate fluctuations in multi-currency scenarios.

Q13. What happens when I click "Save" on the "Record Invoice Payments" modal?

A: When you click "Save" on the "Record Invoice Payments" modal, the payments will be recorded and the invoices will be marked as paid.

Q14. Can I view the total cash received during the bulk/batch payment?

  • Yes, you can view the total cash received during the bulk payment flow. The total cash received will be in the payment account currency.

Q15. Is bulk payment the same as batch payment?

  • No, bulk payments create 1 payment record for all the selected invoices. 

  • Batch payments create a single payment for all the selected invoices.

Q16. Can I record a payment before selecting the invoices it pays?

  • Yes. Record it as an unapplied payment, then apply it to invoices later.

  • See Unapplied Payments (Sales).

Did this answer your question?
😞
😐
😁