| bivio offers users the ability to easily upload/import their
data from iCLUBcentral® Club Accounting (NCA) software. An extremely high
percentage of the imports are completely successful. However, a very
small number of imports result in apparant data inconsistancies.
These problems are generally the result of the legacy of bugs within
the iCLUBcentral® Club Accounting software and/or users importing data from
out of date versions of iCLUBcentral® Club Accounting software.
Below is a list of known import problems and possible fixes. Since
bivio preserves historical transactions that have been imported, the
fix may require that a transaction be modified in iCLUBcentral® Club Accounting
and the data re-imported.
Invalid sell lot - This is visible on the Capital Gains and
Losses report by a lot which has no acquisition date (unless the
investment is average cost (or is a short sale?)). It can cause the
Income and Expense Statement to disagree with the Capital Gains and
Losses report. It is caused by deleting and reentering a purchase
after a sale has already been recorded. It can be fixed in NCA by
deleting and reentering the sale.
Taxable items recorded after a club has liquidated - This is
visible when then Income and Expense report values don't match the
Member Tax Allocations report totals. It will cause a difference
between the 1065 totals and the sum of the K-1s. It can be fixed by
either moving the withdrawals until after the last taxable item, or
moving the taxable items before the withdrawals.
Different allocations calculated between NCA and bivio -
Normally, bivio preserves the imported tax allocations. If the
imported data's Income Statement doesn't exactly match the totals on
the Member Tax Allocations report, bivio will recalculate the
allocations for the last full tax year.
Dangling account transfer entries - Some imported data has a
"Trsfr To" with no corresponding "Trsfr From". This can be fixed by
deleting and re-entering the account transfer.
Unit distributions for a year in which a member had a full
withdrawal - In this case a member incorrectly receives a unit
distribution, even though they had a full withdrawal during the year,
and own no units at the end of the year. This causes the units to
carry over into the next year, and for that year's unit distributions,
and so on. It causes a member to show up with a percentage ownership
in bivio's Member Summary page. To fix it, the club must redo the
original distribution which caused the error, re-audit from that point
forward, and repeat for every year after the incorrect year (using
iCLUBcentral® Club Accounting).
Related help topics:
|