Skip to contentTalk to us
العربيةLog inStart free
Excel to system

Turn your Excel accounting sheet into an accounts and expenses system

An Excel accounting sheet serves you until the tabs and formulas multiply, and then every statement becomes a manual search. Upload your accounts file and Fanann proposes a system with a chart of accounts, entries linked to their accounts, a statement for every customer and supplier, monthly income and expense reports, and roles for who enters and who reviews. Your past entries come with it.

Start with your fileThe steps
Excel and CSV up to 10 MBYour data is imported with the build
Why now

When does the Excel file stop being enough?

1

Formulas that break silently

A row inserted in the wrong place or a cell typed over a formula changes the total, and nobody notices until month end.

2

Every statement is manual work

To see a customer’s or supplier’s balance you filter, add up and copy into a new sheet, then do it all again next month.

3

No line between who enters and who reviews

Whoever opens the file can edit an old entry, and nothing shows that an amount changed after the month was closed.

Sample columns

What does each column in your file become?

These are common columns in a file like this, what Fanann reads from them and how they show up in the system.

Column in your fileRead asBecomes in the system
DateDate

A date field and the basis of monthly reports and period closing.

DescriptionText

The entry’s description, used to search the log.

AccountCategory

Becomes a chart of accounts, with every entry linked to its account.

DebitMoney

A money field totalled in the account balances.

CreditMoney

The matching money field; together they give each account’s balance.

Payment methodCategory

Cash, transfer, card: a filter and a by-method report.

Customer or supplierCategory

A customers-and-suppliers module, and from it a statement for each party.

If your file is an accounts-and-inventory workbook with sheets for items, sales and purchases, upload the whole file: Fanann reads each sheet and proposes linking movements to items and accounts. If the amount sits in one column with a “type” column (income or expense), that is fine too; review both types before the build.
The proposed system

What does Fanann propose for a file like this?

A proposal you see before the build and can adjust: switch off a module, rename a field, or add what is missing in a sentence.

Screens

  • An entries log with search and date and account filters
  • A chart of accounts with each account’s balance
  • A statement for every customer and supplier
  • A new-entry form with correctly typed fields

Reports

  • Income and expenses by month
  • Customer and supplier balances
  • Expenses by account and payment method

Roles

  • An accountant who enters and edits entries
  • A manager who reviews and sees the reports
  • A read-only account for an outside reviewer
The steps

Five steps to turn your Excel accounting sheet into an accounts and expenses system

  1. 1

    Prepare the accounting sheet

    One entry per row, amounts as numbers with no currency symbol, and dates in one format. Spell account, customer and supplier names consistently, and delete subtotal rows: the system works them out itself.

  2. 2

    Upload it in “Excel to App”

    Upload the .xlsx or .csv file, up to 10 MB. If each month or activity has its own sheet, upload the whole file and it is read sheet by sheet.

  3. 3

    Review the types and links

    Check that debit and credit were read as money and the date as a date, that accounts appear as categories with the right values, and review the proposed link between entries, customers and suppliers.

  4. 4

    Adjust the proposed system

    Describe your rules: who enters and who reviews, whether an entry is locked after the month closes, and which reports your accountant needs.

  5. 5

    Build it and reconcile the balances

    After the build compare each account’s balance in the system with its balance in the file. Once the numbers match, record new entries in the system alone.

An example description to send with the file

An accounts system for a building-materials shop. The accountant enters sales, purchases and expenses, and the manager only sees reports. I want a statement for every credit customer and every supplier, a monthly expenses-by-account report, and no editing of any entry after the month is closed.

Plainly: the limits you should know

.xlsx · .csvExcel and CSV files. From Google Sheets: download it in either format, then upload.
10 MBThe maximum size of one file.
5,000rows per sheet, roughly, are imported at build time; bring in the rest later from the Control Center.
PlansPlans differ in what they include, and that can change. What your plan includes is on the pricing page.
FAQ

Questions people ask

How do I turn my Excel accounting sheet into an accounts system?
Upload the accounts file in “Excel to App”. Fanann reads the columns and proposes a system with a chart of accounts, entries, statements, reports and roles, then builds it with your past entries inside.
Does it work for an accounts-and-inventory workbook?
Yes. Upload the file with all its sheets: items, sales, purchases and entries. Fanann finds the columns that link the sheets, such as the item code or supplier name, and proposes a system that brings accounts and inventory together.
Do Excel formulas and totals carry over?
What carries over is the data, not the formulas. Balances, totals and statements are built as logic inside the system and worked out with every new entry, so mention any special calculation you rely on in the description.
Does it meet zakat, tax and e-invoicing requirements?
Do not assume so. It is a system you build for your business with your data, not software certified by any authority. If your country’s rules require e-invoicing or certified software, state what you need in the description and check the official source and your accountant before relying on it.
Can my outside accountant see the books?
Yes, with an account whose role you set: read-only, or entry and review. Everyone signs in with their own account, so you stop emailing the file around.
How many entries can I import from the Excel file?
Fanann accepts Excel and CSV files up to 10 MB. About 5,000 rows per sheet are imported at build time, and Fanann tells you what was left out. Any entries beyond that can be imported later as a CSV from the Control Center.
Is turning my entries file into a system free?
Signing up to Fanann is free. What each plan includes, Excel to App among it, is set per plan and can change, and the pricing page shows what applies now. After the build you manage your entries from the Control Center.
Excel to system

Other files that become systems

Excel to App

The feature page: how Fanann reads your file, what it proposes and how it builds the system with your data inside.

See the feature

Customer management system (CRM)

Your customer sheet becomes a CRM: a card per customer, a contact log and follow-ups nobody forgets.

Customer namePhoneCitySourceSteps and columns

Inventory and warehouse system

Your item sheet becomes an inventory system: live balances, low-stock alerts and a movement log per item.

Item nameItem code (SKU)QuantityReorder pointSteps and columns

Invoicing system

Your invoice log becomes a system: invoices per customer, a clear payment status and a list of what is overdue.

Invoice numberCustomerInvoice dateDue dateSteps and columns

Reservations and booking system

Your appointment sheet becomes a booking system: a clear calendar, no double bookings and a history per client.

Client namePhoneServiceStaff memberSteps and columns

Employee and HR tracker

Your staff sheet becomes a system: a file per employee, leave balances and requests that get approved instead of messaged.

Employee nameEmployee IDDepartmentJob titleSteps and columns

How to turn an Excel file into a complete system

The full step-by-step guide: preparing the file, uploading it, reviewing what Fanann proposes, building, then the day you move from the file to the system.

Read the guide
Accounting software that fits your businessYour stock sheet becomes inventory softwareInvoicing software that fits your businessHow to turn an Excel file into a complete systemControl Center: manage your data after the buildPlans and pricing

Your file is ready. Your system is one upload away.

Upload the Excel file, review what Fanann proposes and get a system running on your data. Signing up is free.