From what I can see in my accounting system, the reconciliation report doesn't seem to reflect the reconciliation data. However, you can go back into the reconciliation function and select a previous reconciliation date to see the beginning and ending balance and what was included on that statement.

... not that that helps you any, with your report. I think the report is broken, unless I am just misunderstanding it.

I believe the tax type you are referring to comes from the tax types you have configured under setup.

Are you looking at "Banking Reports" -> "Bank Statement w/Reconcile" ???

The reconcile bank account function (under banking and general ledger) shows outstanding transactions. If you enter the ending balance from the bank statement, it will show the difference for reconciliation.

Please clarify if you are looking for something else.


(1 replies, posted in Banking and General Ledger)

Someone else has probably figured this out already, but I was working through a quick entry for my payroll and I was struggling with how to record a credit for net pay as the last line. Remainder would only post a debit amount.

So, my base amount is gross pay.
My first line item is the remainder to payroll expense
My next line item is the percentage (negative percent) for FICA withholding, which is added to base (because it is a negative #, the amount of base is reduced)
Next I have fixed amounts for federal and state withholdings (because I'm lazy and my the base salary doesn't change); each of those is a negative number which is added to the base amount (again, it reduces the base pay)
Finally, since remainder only records a debit, I have a -100% of base for the check amount that is credited to my bank account (net pay)

So, there is an entry for gross pay, a deduction for FICA (percentage), deductions for state and federal income taxes, then the net amount is calculated as a negative 100% of base (which has been reduced by deductions).

I hope this is clear. It took me a while to figure this out.

Screen shot of quick entry


(4 replies, posted in Banking and General Ledger)

Assets = Liability + equity because equity is treated like a liability.

If I understand you, correctly, you essentially have an asset account (think of it as a bank account) that collects contributions from the landlords of the properties you manage.

When you enter a payment from a landlord, you're going to debit the bank account (asset) and credit the accounts payable account that you set up for that landlord (I would recommend a payable account per landlord for tracking).

When you pay out for a repair, the money would come from your asset account (a credit) and the balancing entry would be applied as a debit to the accounts payable account.

That is how I would do it. Someone else may have more experience with that sort of business.


(4 replies, posted in Banking and General Ledger)

Retained earnings is a liability because it belongs to the owner(s) or stockholders of the company. When the owner makes an investment in the company it is essentially a loan.

I'm not sure about your situation, but I would think that the payments you receive from landlords are an accounts payable (liability), similar to loan you had to repay. Then, as you incur expenses, you could post them against the payable and record the amount of escrow in a bank (capital) account. As you pay for repairs and take money out of the bank account, you'd record the balancing entry against the account payable, reducing the amount owed.

I haven't done anything like this in FA, so I'm not sure exactly how that would work, but generally the owner's equity account would not be involved in your day-to-day business. You'd at least want a payable account for each landlord.


(1 replies, posted in Accounts Receivable)

I've read this 10 times and I don't understand what you have or what you're trying to do with it. Maybe it's just me, but could you try this again? What is the amount of the invoice? Does the system show the invoice unpaid? Where is this credit balance? (customer account, Account Receivable in general ?) How did the credit get recorded in the first place? Could you void the original credit and just re-apply the credit to the customer invoice?


(26 replies, posted in Reporting)

This is the result of a change from PHP 7.1 to 7.2, as I understand it. In 7.1 and before, a count(NULL) would return zero. Now it issues an error. Your correction should work fine.


(10 replies, posted in Accounts Receivable)

@chunket I'm not understanding your problem. My business has no inventory. All of the items I have in my database are either "charges" or "services". FA does not perform inventory control on any of those items.

Would it be alright to enter a payment voucher for the 10000, and then make a separate journal entry to move the move the 5000 from the advance account to the payroll expense account?

Looking at that report, I see on string from the x_comments table, and the line item descriptions are from x_purch_order_details. You may be able to see what is happening if you look at the contents of those tables outside of FA.

Sorry, if this is no help.

There must be something in the database that didn't update. Is there something in the x_comments table?

p.s. I'm not sure which report is 209. Based on your description, it is a report on purchase orders. That would most likely be looking at x_purch_order_details.description.

Browser cache?

Having researched this, it looks like a problem with the Trial balance, not with the invoice referenced by the report. This post probably belongs in the Reports section.

I was going to search the GL for an entry in "Foreign exchange gain", but there is no such account in my COA. I guess this is something the Trial Balance report calculates??? It still doesn't make sense when there was no currency conversion used.

I was just looking at my trial balance and I have a foreign exchange gain of $0.01. When I click on the reference link, it brings up and invoice in USD (my local currency). Actually all of my customers pay in USD. How can this happen? Is it just in the trial balance or is there a GL entry with a foreign exchange gain?

I've been digging into this a bit deeper.

When I make a deposit using the "bank deposit" function, the 0_gl_trans for the deposit does not get the dimension_id set.

When I make a journal entry and debit or credit my bank account, the dimension_id does get saved in 0_gl_trans.

Therefore, depending on how I recorded the transaction, some amounts are reflected in my trial balance under current assets, and others (normal bank deposits) are not.

The results are inconsistent. Apparently, it is the dimension_id in the GL that is used for reporting and that is set inconsistently.

I hope this is clear. I'm at the end of my day, so I'm a bit exhausted.

Just to be clear, the dimension selections are not recorded on the bank transaction (x_bank_trans). Apparently they are recorded on the matching entry. The problem I see is that the balance sheet is inconsistent when selecting by dimension. For some reason, my bank deposits by dimension don't show up in the balance sheet, but journal entries that result in deposits to a bank account do.

I could have this all wrong, but I am sure of one thing, dimension_id and dimension2_id are always zero in the x_bank_trans table.

@joe I mostly agree. The only problem is when I want to record revenue by dimension and that revenue is not from an invoice/sale. When I try to evaluate profit/loss based on dimension, the revenue is misrepresented.
However, I understand that the bank entries would be redundant with sales when revenue is recorded against an invoice. I don't think this question has a simple answer. However, I had to stop using dimensions to calculate profit/loss because bank deposits simply discard the dimension selection.

At the very least, the interface shouldn't suggest that a dimension can be recorded with a bank deposit when it is intentionally discarded. I spent some time trying to figure out why my dimension selections weren't being saved. I thought it was a bug until I reviewed the code and saw that no dimension information is ever passed to a bank transaction. As I said earlier, having the fields in the database, and a selection in the UI, are a real source of confusion.

I have my company VPS with Jumpline

FYI: I just added a test entry into the test company using a dimension, the dimension was NOT saved in the bank transaction. That is consistent with what I found when I was investigating in 2.4.3. I don't think it's a bug because the dimension is clearly not set and the functions for saving bank transactions do not accept a dimension argument.

What is confusing is that the dimension_id exists in the x_bank_trans table, as it is never set.

I believe it has to do with how the GL entry was made. I only see the edit on journal entries, not on GL entries that were automatically created as a consequence of an invoice or payment, etc.

The last time I checked, the dimension wasn't recorded on bank deposits. It was just being discarded. It was only being recorded on income and expense. That may have changed in 2.4.4.

Sorry, this doesn't answer your question.

p.s. This post probably belongs in "Reporting" rather than bugs. There are discussions there on how to customize reports.

I've been using VPS(s) for about 10 years and mostly I've had good experience with up-time. Of course, I am an experienced sys-admin. The only service I found that was really bad; very poor up-time (down for over 8 hours in the first month), and take no responsibility for their end of keeping the server running (e.g. network connectivity, container integrity), was HostWinds. They advertise 99.999% up-time, but it means nothing the way they define up-time.

I agree that setting up and managing a VPS requires knowledge and time. I could not survive without a reliable VPS. The alternative would be to build a mini-data center near my office and pay for the hardware, the building, the air-conditioning, hardware maintenance, off-site backups, and the Internet pipe. A VPS is really a good deal, if you require a dedicated server and you find an honest, reliable hosting company.

I'll have to look into VestaCP. Thanks for the tip.