"Invoicing made simple" for simple people! |
Screenshots can be found on this blog article: Webix blog.
iFact is an invoicing web application that I wrote in a spare moment between projects. This is a personal tool to help me create my invoices and with minimal invoices management, like: marking them payed, reporting overdued invoiced, see anual revenue, export to a spreadsheet via SheetJS.
The name comes as an acronym i - letter that was imposed by Apple™®© and Factură - which means invoice in Romanian ... and also sounds interesting if you pronounce it in a certain way in English ... and this was done on purpose.
This is a Single Page Application web applicaion written with Webix framework, running as a couchapp directly from Apache CouchDB server. For installation and development purposes, the application may be synchronized back and forth from local folder to CouchDB with AC:zap:DC utility. The invoices are generated as PDF files via PDFmake framework using Handlebar framework for templating. All data is stored in JSON format.
Pre-requisites:
- CouchDB version 1.6.1 or later installed. Create
ifact
database and add one user as administrator, let's say user name: manager with password bigboss. git
tool- AC⚡DC tool
Clone this repository to local machine.
git clone https://github.com/iqcouch/ifact.git
Copy the acdc
executable to parent folder of ifact
and push the application to your CouchDB instance:
./acdc push -db ifact -URL http://manager:bigboss@localhost:5984
The application should be availble at: http://localhost:5984/ifact/_design/app/index.html. Login as manager.
Congratulations!
You have now created a new installation of iFact application. This instance has no data, yet.
The home page is the from where you fill in your profile. You should provide identification information about your company. This information includes: company name, address, identification nubmers and fiscal data, also you can add several bank accounts. Normally you are supposed to fill in this page only once. Also fill in the series and the starting serial number for your invoices.
On the left side you have a drawer menu that will allow you to define the other entityes: customers, contracts, invoices and payments.
A customer is an entity similiar to yours and will be the your business partner, the one you will invoice. The input data is similar to yours, the only diference is that there are multiple customers and you are the only supplier. Customers are created once and they can not be deleted.
Once you defined a customer then you may create contracts. The contract is a legal basis on which you will perform business with your customers. Please keep the copy of the contract in a safe place. Contracts have an expiry date. Once they are created they can not be deleted.
The next step is to deliver the services or goods you signed the contrat for and start invoicing!
The next important step is to emit invoices for your services according to the contract. The application is based on PDFMake to produce the actual electronic inovice.
There are two templates to choose form: EN and RO. They correspond to English/European and Romanian invoice templates. The templates contain a couple of fields that can be filled in by the user. You must provide a minimum amount of information:
- the bank account that you want the invoice to be payed to
- the customer
- VAT value as a percent
- the date of issue
- the description of the services provided
- a formula to compute the value or the actual value of the invoice line
Pleas use Preview button to inspect the inovice. You will see a draft PDF in the right panel, please note that the invoice number is the last valid number that is in the database. If you are happy with the result, then press Create Invoice button, this time you will see the new invoice on the right panel with a diferent invoice number - a real, valid, invoice number.
In order to close the cycle you need to keep track of the payed invoices. The Payments will allow you to visualize the state of your invoices. Invoices are New once you created them. They will become Due if the current date is greater or equal to invoice due date and the invoice was not entirely payed. Once the invoice is entirely payed it will become Payed.
Payments allows you to keep trak of your invoices and to figure out your future cash flow. You may edit the invoice, please use this feature being fully aware of what you are doing. Once the invoice enters the legal process, I do not recommed to use edit functionality. There is a view button allowing you to get another copy of the invoice.
The Dashboard is the place to look from time to time in order to understand the overall situation of your business. Basicaly you have a summary of the Year to Date invoiced, payed and due sums. You have two graphs showing the Year to Date income (invoiced vs. payed) and the other graph, showing the comparative Monthly invoiced for each year of activity.
iFact has data export and import facilities. On the Supplier view, right side you will find a couple of buttons allowing you to work outside the box. You can export data, like a financial statement: invoiced vs. payed per invoice, in Excel. You can export the entire database - only data, without the application, in JSON format - like an old database dump, and import data in JSON format (see file iFact_DEMO.json).
Actually I do recommend to start with an empty database and import the iFact_DEMO.json file in order to play with the application.
You can synchronize the application and data with another CouchDB compatible system, like Cloudant or CouchBase or PouchDB Server. I tested succesfully the replication with Cloudant and CoucDB 2.0.
Have fun and enjoy life!