Foreign Currency Conversion of Fixed Assets

Companies primarily enter fixed assets in functional currency, which is the currency used for its principal business. So a U.S. based company would enter most of their assets with U.S. dollars. If they own subsidiaries in other countries than those assets can be entered with a different reporting currency. A currency conversion module would then be necessary to report in either functional or reporting currency.

Bassets eDepreciation includes an optional foreign currency module that allows the user to easily generate depreciation reports in different currencies.  The Currency Conversion module enables each individual asset to be stored in the native currency of that country. This flexibility permits reporting of the monthly depreciation expense in appropriate dollar amounts as needed.

Here is a screen shot of a sample exchange rate:

Foreign Currency 2

This form allows for an unlimited list of defined currencies. For each currency, you can then select the effective date, exchange rate and rate type. This combination of variables covers many different reporting scenarios based on the choice of rate type.

As an example, if the base currency were US Dollars, an asset with a currency type of EUR (Euro) would have its numbers multiplied by the correct currency conversion rate.  On the other hand, if an asset was stored with US Dollars and the report was generated for EUR, the dollars would be multiplied by the inverse rate (1/rate). The conversion rate for the current reporting period can be entered at any time prior to the report being generated.

An integrated foreign currency module greatly reduces the errors that can occur when using a spreadsheet or manually calculating conversions. All standard reports can be run in either functional or reporting currency to display cost, depreciation calculations and net book value using the selected currency.

Questions or comments on this post? We invite you to respond in the space below.

More information about Bassets eDepreciation software can be found at Bassets.net. While there you can set up a demonstration, download a free evaluation copy and get a personalized pricing estimate.

Depreciation Expense of Property, Plant & Equipment

Depreciation Expense of PropertyIn a recent opinion piece by Michael Evans on CFO World, he gives a very clear description of how companies can improve depreciation of corporate property:

A common problem in corporate real estate is when a property comes to the end of its useful life and needs to be sold and there is the dawning realization that the net book value of the property is well in excess of the potential sales proceeds. Bad news – an unwelcome hit to the profit and loss (P&L) account and substantially lower cash receipts than may have been expected.

In the story, he details several points that are often overlooked:

  • Owned properties are recorded at historic costs
  • Property is usually depreciated using a straight line method
  • Cost increases with capital improvements
  • Replaced assets should be written off
  • Assign the correct residual value
  • Employ the proper useful life

The combination of overinflated cost bases and excessive useful lives and residual values that bear little relation to the market mean that all too often the depreciation of property assets is understated and net book values are overstated in property accounts. So when you’re looking to sell that corporate property and you’re facing a huge loss – don’t blame the corporate real estate team, don’t blame the property market – blame the depreciation policy, stupid.

Read Full Article Here:

Questions or comments on this post? We invite you to respond in the space below.

More information about Bassets eDepreciation software can be found at Bassets.net. While there you can set up a demonstration, download a free evaluation copy and get a personalized pricing estimate.

Bassets eDepreciation – Data Import

Basset eDepreciation - Data ImportThe Bassets eDepreciation Data Import Module will easily import your existing fixed asset data. All selected fixed asset records will be imported from either Excel, ASCII text files or other fixed asset software programs.  A great feature is our on-screen preview which displays the existing fixed asset data in a simple spreadsheet like grid to assist in the field mapping. Bassets also allows for customized mapping of each field. A user defined import map allows each field in the source fixed asset data to be directed to the corresponding Bassets field and you can preview user selected sample fixed asset data for each field. No need to worry about mistakes because Bassets will verify the accuracy of all depreciation methods, first year conventions and recovery periods based upon the property type and acquisition date and then check each fixed asset record against the defined field lengths. When you process the import Bassets calculates fixed asset depreciation to tie out with existing total accumulated depreciation. It imports only the required depreciation schedules and will automatically build drop down or pick lists for any Master List fields.

Watch this video to see the details:

Questions or comments on this post? We invite you to respond in the space below.

More information about Bassets eDepreciation software can be found at Bassets.net. While there you can set up a demonstration, download a free evaluation copy and get a personalized pricing estimate.

Excel Spreadsheet Errors Can Be Very Costly

Excel-errorIn a recent article published on CNNMoney, Steven Gandel, a writer for Fourtune examines some severe errors in Excel spreadsheets: The popular Microsoft program has been implicated in the financial crisis, Europe’s growth problems, the U.S.’s weak economic recovery, and pretty much everything else.

Prominent financial blogger James Kwak calls Excel “one of the greatest, most powerful, most important software applications of all time.” But perhaps we ask too much of the program, or perhaps of our ability to cut and paste. In the past few years, Excel has been implicated in some of the biggest blunders on Wall Street and in finance in general.

In the article, he then details some mistakes which had significant implications on the spreadsheet owner’s organization:

  • Two Harvard professor’s incorrectly predict economic growth
  • Risk officers at JPMorgan underestimate potential investment risk
  • MF Global bets on Europe with outdated information
  • Barclays misses nearly 200 hidden rows of bad assets which then became part of the deal for Lehman Brothers
  • Utah’s office of education vastly underestimates public school enrollment
  • Fannie Mae profitability was grossly overstated
  • Native Americans miscalculate the value of NYC

So while Excel is an excellent tool for performing financial calculations, it is not without problems. It is very easy to make a mistake in a formula, miss hidden rows or incorrectly copy & paste some key information. We are not recommending that you stop using Excel, but as you can see from this article, you should proceed with caution.

Read Full Article Here:

Questions or comments on this post? We invite you to respond in the space below.

More information about Bassets eDepreciation software can be found at Bassets.net. While there you can set up a demonstration, download a free evaluation copy and get a personalized pricing estimate.

Custom Annual Depreciation Report to Meet State Regulations

Custom ReportsThere are standard fixed asset reports that are run on a monthly basis to track acquisitions, disposals and depreciation expense. Additionally, annual reports are necessary to meet normal year end requirements. But what do you do when a state or other entity requires a custom report?

Recently one of our clients faced just such a situation. The State of New York requires hospitals to submit an IRC (Institutional Cost Report) as detailed here:

http://www.health.ny.gov/facilities/hospital/rate_setting/

As part of this filing, they needed to recalculate depreciation using sum of the years’ digits method. In the past they have manually manipulated their fixed asset data to produce this report. This was very time consuming and caused a lot of questions and confusion.

This year they requested an integrated enhancement to our reporting to automatically generate the necessary report. After some analysis and design, we were able to meet their request with custom programming for a very reasonable fee. This custom annual depreciation report not only solves the problem for this year, but will also be available next year and going forward to avoid this annual headache.

As a best-of-breed fixed asset solution Bassets is very adept at meeting these special requests from our clients. If you have any reporting requirements that are difficult to comply with, bring the challenge to our support team. We are eager to evaluate any fixed asset or depreciation requests that you may have.

Questions or comments on this post? We invite you to respond in the space below.

More information about Bassets eDepreciation software can be found at Bassets.net. While there you can set up a demonstration, download a free evaluation copy and get a personalized pricing estimate.