Submit bank transactions

In addition to purchase and sales invoices, your administration consist largely of bank transactions. Make sure Yuki has access to all your business bank accounts, credit card statements, and any online payment providers.

Keep business and personal finances strictly separate

It happens in every business that business and personal transactions get mixed up. For Yuki, this isn’t a problem in principle, but it’s advisable to keep your administrarionas clear as possible.

A few tips to manage this better:

• Separate account: Open a separate bank account for your business expenses. Pay for business transactions from this account and personal expenses from your personal account.
• Business debit card: Apply for a business debit card and, when making a purchase, consciously consider the nature of the transaction (business or personal).
• Occasional credit card expenses: Do you rarely use your credit card for business? In that case, simply submit the individual receipts (invoices/receipts) and note on them that you paid for these personally.
• Multiple partners/owners: Do multiple partners make personal expenses or personal withdrawals from the business account? If so, always clearly state in the description who this was for.

Three methods for importing bank transactions

There are three ways to import your transactions into Yuki. Below you’ll find the details for each method.

Method 1. Automatic accounting link (Recommended)

If you bank with ABN AMRO, Rabobank, ING, or Knab, you can have your mutations automatically updated in Yuki on a daily basis via a direct accounting link.

For a detailed description of the ABN AMRO, ING and Knab accounting link see category Links.

For a detailed description of the Rabobank accounting link see article Rabobank accounting link.

Method 2. Download and upload bank files

Almost all banks offer the option to export transactions for a specific period. 

You can then manually upload this file to Yuki via the PO Box.

Download bank file from bank account, credit card, or online payment provider

When you manually download files from the bank and upload them to Yuki, these are the three most important steps to take to prevent errors:

• The date check: In Yuki, check the bank account for the date of the last transaction. You’ll find this date in the last column of the overview of all bank accounts in Yuki.
  Make sure the new export file from the bank matches that date exactly to prevent gaps or duplicate entries.
• The correct export format: When exporting from the bank environment, always choose CAMT.053 or MT940. Only choose CSV if the other two are truly unavailable, as CSV files are more prone to import errors.
  
  For a detailed description, ssee article List of supported bank and online payment providers export formats.
  
  No original bank file available?
  If you do not have an original export file for your “historical transactions,” you can use the standard Yuki bank import format.
  
  For a detailed description and an example of this standard Yuki bank import format, see article Standard Yuki bank import format.

Upload bank file

Upload the downloaded file directly to the Yuki PO Box. Yuki automatically recognizes the bank file format and (if it’s a new account number) immediately creates a new bank account in the system.

For a detailed description, Upload files from PO Box.

Method 3. Scan bank statements and credit cards (only in exceptional cases)

Yuki accepts scanned paper statements only in exceptional cases, when the transactions are no longer available electronically.

Business credit cards

Submit only statements from your business credit card. Statements from a personal credit card do not belong in Yuki (you should manually enter business expenses from these using a separate receipt or invoice).

• Scan the credit card statements if there is no electronic accounting link.
• Always submit the underlying receipts or invoices whenever possible for VAT recovery purposes.

TIP!

Credit card statements from ING Bank can be submitted via a downloadable PDF file.