Back

About Accounts Payable

Learn how to manage your bank accounts within Factorial, simplifying your financial operations through seamless integration and automation.

Streamline your invoicing with Factorial's Invoice Tracking System. Easily upload invoices and use our OCR technology for automated data extraction, saving time and reducing errors. Simplify accounting entries and gain better financial control.


Where to find Invoices

  1. On your sidebar, go to Spending → Invoices

Invoices payment status

Track your invoice payment status here. Access detailed information to manage your finances effectively and ensure timely vendor payments. Key metrics provided include:

  • Total: total amount of payments recorded.
  • Paid: total amount that has been successfully paid.
  • Pending: invoices that have not been paid yet but are within the payment timeframe.
  • Due: invoices that remain unpaid past their due date.
  • Number of pending and due invoices: a count of pending and overdue invoices.
  • Base amount and taxes: a breakdown of the invoice amounts, distinguishing between the base amount and any associated taxes.

💡 These data are dynamic and will adjust based on the filters you set.

 

How to manage the status of the invoices

Your invoices can undergo four distinct statuses:

  • To review: uploaded invoices enter this stage for accuracy checks. After verification, click Approve or Reject.
  • Approved: invoices are ready to be paid.
  • Rejected: invoices are marked as Rejected due to discrepancies or errors.
  • Paid: invoices that have completed all the processes and have been paid. You can mark them paid there or though bank reconciliation.

To change the status:

  1. Open the invoice you want to update
  2. Select the action

- Invoices that are rejected cannot be moved to other statuses.
- Invoices under review can be moved to the statuses: Rejected, Approved, or Approved and paid.

 

How to upload invoices in bulk

  1. In the Invoices section, click Upload invoices at the top right corner
  2. Choose a file or drag it into the designated area
  3. Click on Finish and close
  4. Our OCR system will automatically read the data and autofill the information
  5. Review the prefilled data for accuracy
  6. If necessary, you can create a new vendor directly from this page
  7. Click on Approve

How to receive invoices in the Mailbox

You have a mailbox to receive and view invoices by email. It functions only as an inbox, so you cannot send or reply to emails from this address.

  1. Go to the Invoices section
  2. Copy the email address at the top right corner
  3. All your invoices will be received in the mailbox and automatically read by our OCR

How to export invoices

  1. Go to the Invoices section
  2. Click three dots icon at the top right corner
  3. Select Export invoices
  4. Choose the desired format, apply necessary filters, and configure column names to suit your requirements
  5. Click on Save

💡 You will receive an email with the exported file, and you can also find it in your documents section in Factorial.

 

How to manage bank accounts

Learn how to manage your bank accounts within Factorial, simplifying financial operations with seamless integration and automation.

1. Manually Adding a Bank Account

  1. Click on the 'Add Account' button.
  2. Select the legal entity for which you want to add the bank account.
  3. Choose 'Add Manually' and click 'Next'.

Basic Information: Enter the necessary details to initiate data aggregation:

  • Account Alias: Assign a unique name for easy identification.
  • Account Format Options: Choose one from the following:
    • IBAN
    • Account Number + Sort Code
    • Account Number + Routing Number
    • Bank Name + Account Number
    • CLABE
    • Other
  • Currency: Specify the currency of the account.

Your account will be automatically created upon completion of these details!

 

2. Adding a Bank Account via Open Banking

  1. Click on the 'Add Account' button.
  2. Select the legal entity to which you want to add the bank account.
  3. Choose your bank from the provided list and click 'Next'.
  4. Click 'Finish and Synchronize'. You will be redirected to your bank's login page to securely log in.

Enter your bank login credentials to start importing your bank accounts and transactions. Your bank account will be connected with Factorial for 90 days, allowing us to keep your transactions up-to-date for easy reconciliation with invoices and facilitating smooth bank reconciliation processes.

Reconnect your bank account

Past 90 days, we will ask you to reconnect so we can continue having access to the bank transactions. You will see the bank account with the “expired” tag.

 

Additional Information

  • What does 'Finish Account Setup' mean?
    • You should review certain bank details such as account alias, IBAN, or currency, and we will ask you to select a ledger account for the bank. This step is necessary to create the corresponding journal entries in your accounting system.
  • What does 'Complete Account Creation' mean?
    • This status indicates that you started the process of connecting to a bank but did not complete it.

 

How to delete an account?

Within the account, press on view details and there you will find the option to delete the account.

 


Key functionalities in the Bank accounts section

View details

Access a side panel displaying account details, including legal entity, beneficiary name, IBAN, and currency.

  1. Click on View details

Inside, you will find:

  • Account Information: Displays details such as the legal entity, beneficiary name, IBAN, and currency.
  • Ledger Account Selection: Allows you to select the corresponding ledger account for the bank.
  • Last Synchronization: Shows the most recent synchronization date with the bank.
  • Delete Account: If you need to remove the bank account from the system, you can do so here.

 

Import bank transactions

Upload a file to import your bank transactions into Factorial. Simply drag and drop the completed template, which we provide for you to fill out with data exported from your bank, into the system.

This step is essential for bank accounts added manually. For bank accounts connected via Factorial, it is optional but recommended if you need to import past transactions that were not previously captured.

 

 

To import bank transactions:

  1. Click on Import bank transactions
  2. Download our template
  3. Retrieve the transaction data from your bank and fill the template accordingly
  4.  Drag and drop the filled template into Factorial. If any error occur, we will guide you through correcting them until the upload is successful
  5. Click on Import data

 

Export transactions

Customize and export your transaction data in various formats, tailoring the exported information to your needs.

To export transactions:

  1. Navigate to the desired bank account section
  2. Click on the three dots icon and select Export transactions
  3. Choose your format, apply necessary filters, and configure column names to suit your requirements
  4. Click on Save

💡 Coming soon: Bank Account aggregation
View all your accounts in one place for a consolidated overview, eliminating the need to switch between multiple banking interfaces or applications.

 

Bank reconciliation

Bank reconciliation involves matching your bank transactions with business records, including customer invoices, vendor bills, and payments. This essential process is required for most businesses and provides multiple benefits. It helps minimize errors in financial reports, enhances the detection of fraud, and optimizes cash flow management.

Thanks to Factorial's bank reconciliation AI, the system automatically pre-selects and suggests matching invoices, streamlining the reconciliation process.

 

 

Overview of the Bank reconciliation view

The bank reconciliation interface is divided into three key sections: transactions, counterpart entries, and resulting entry.

  • Left panel: displays bank transactions that are pending reconciliation. You can utilize the filter to toggle between pending and reconciled transactions
  • Right panel: here, you can match transactions with the approved invoices and view counterpart entries. Only approved invoices are eligible for reconciliation

Reconciliation process

Follow these steps to reconcile a bank transaction:

  1. Select a bank transaction: click on the transaction you wish to reconcile
  2. AI suggestion: our AI tool will automatically suggest the corresponding invoice
  3. Reconcile: If the details are correct, click on the "Reconcile" button
  4. Confirmation: the transaction will be marked as reconciled and the invoice status will update to 'Paid'.
  5. Rejection option: if necessary, you can reject the AI’s suggestion and choose another invoice manually

Scenarios covered

  1. One Invoice - One bank transaction
  2. Partial payment: one Invoice → 1st bank transaction + 2nd bank transaction
  3. Several Invoices - One bank transaction
  4. One invoice - Several bank transactions
  5. Reconcile without a document

If you need to postpone reconciling a bank transaction, you can use the snooze function. Simply select the transaction, click on Snooze, and choose the duration for which you want to delay reconciliation.

 

Reconciling within the Invoice section

You can also initiate reconciliation directly from the invoice section:

  1. Access the invoice: navigate to an approved invoice and click on it
  2. Transactions associated: in the invoice details, you’ll find a “Transactions associated” section with a "Reconcile" button
  3. Reconcile: upon clicking, a new view will display all related bank transactions
  4. Complete reconciliation: select the appropriate transaction and confirm the reconciliation

This method supports the same reconciliation scenarios as mentioned before.


How to export your transaction data

  1. Select export format and date range:
    • Choose between a CSV or Excel file and the start and end dates for the transactions you want to download. This allows you to customize the period for which you need the data.
  2. Receive your data:
    • After selecting the dates, the system will process your request. You will receive an email notification with a link to download your data.
  3. Download and review the Excel file:
    • The file you receive will be in Excel format. It includes all transactions, invoices, links to the invoices, and reconciliation details.
    • Download the file from the link provided in the email and save it to your device.

 


Accounting

Chart of Accounts

The Chart of Accounts is a comprehensive list of all accounts used to record financial transactions in an organization's general ledger. You can access the Chart of Accounts under the Accounting section.

Configuration

To import accounts, navigate to the Accounting section and click Import Accounts.

A dialog box will appear, allowing you to:

  • Download a Template: Download an Excel template that includes all the ledger accounts currently used by your company.
  • Upload Completed Template: After entering your ledger accounts into the Excel template, upload it back to Factorial to update your system with the new information.

How to Add New Ledger Accounts

  1. Create a New Account: Easily add new ledger accounts directly within Factorial, ensuring your Chart of Accounts remains comprehensive and up-to-date.

2. Download and Modify the Account Template: Download the account template pre-filled with existing data, add new ledger accounts in Excel, and re-import it to Factorial.

 

Benefits of Having a Chart of Accounts

Having a well-organized Chart of Accounts helps you:

  • Associate ledger accounts with specific bank accounts and vendors, enhancing financial clarity and management.

Automated Reconciliation

Factorial will automatically create journal entries for this segment of accounting, simplifying your reconciliation process and reducing manual data entry.

 

How to Manage and Assign Ledger Accounts

Easily configure and assign ledger accounts to each vendor, bank account, and tax entity with our streamlined accounting settings.

Accessing the Configuration Panel

  1. Navigate to Settings.
  2. Select Accounting to open the configuration panel.

Assigning Ledger Accounts

Bank Accounts

  • Direct Assignment: Navigate to each bank account and assign the appropriate ledger account directly.
  • Via Details Panel: Alternatively, access the "View Details" panel within each specific bank account to make assignments.

Vendors

  • Direct Assignment: Click on each vendor and select the suitable ledger account for that vendor.
  • Via Vendor Profile: Go to the vendor section in the sidebar, and you can add or update the ledger account in each vendor's profile.

Managing Taxes

  • Create and Assign Taxes: Click on Taxes in the accounting settings. Here, you can create and define the taxes your company utilizes.
  • Assign Ledger Accounts: For each tax, such as VAT or other applicable taxes, you can assign the corresponding ledger account to ensure accurate tracking and reporting.

Was this article helpful?

Can’t find what you’re looking for?

Our customer care team is here for you.

Contact us

Knowledge Base Software powered by Helpjuice