Base reports format fields

Hi,

I need to have an input form for expenses and income, my idea was to have the expenses automatically converted to a negative amount when they are input’ed on the form. I have a drop down list of expense types, my expense types are “Income”, “Expense”, “Capital Expense”. Income is invoices paid, expense is lunch or travel, Capital expense is new Laptop.

So when I write a report I can get a very easy income and expense.

Any help would be great.

thanks, Kiselhuis

Hi @Kiselhuis,

qubit hands you a basket of karma

Hmm…that should give you enough karma so you may comment on Answers :slight_smile:

@kiselhuis,

There’s probably a way to accomplish your goal in LibreOffice Base, but have you considered using a more specialized piece of software for your accounting purposes? Depending upon what you need to do with your reports, other software might make your job a bit easier.

GnuCash is a free software accounting program that implements a double-entry bookkeeping system. It was initially aimed at developing capabilities similar to Intuit, Inc.'s Quicken application, but also has features for small business accounting.

If GnuCash doesn’t suit your style, there are several other FLOSS accounting programs – just take a look at this list on Wikipedia:

Hey Qubit, thanks for the suggestion, I am going to try that out!