From Fishbowl
Jump to navigation Jump to search

Icon.Currency.png The Currency module, located in the Accounting group, provides the ability to create alternate currencies and set the conversion rate between the home currency and the alternate currency. Currency rates can be imported and updated from QuickBooks. Currency rates can also be manually imported or imported on a schedule. Both the Icon.Sales Order.png Sales Order module and the Icon.Purchase Order.png Purchase Order module support currency conversion. If currency conversion is enabled in Fishbowl and multi-currency is enabled in QuickBooks, orders will export to QuickBooks with the alternate currency set. QuickBooks automatically creates separate Accounts Receivable and Accounts Payable accounts for each currency that is in use.

Module buttons

New Button.png New creates a new currency.

Save Button.png Save saves any changes made to the currency that is currently open.

Delete Button.png Delete deletes the currency that is currently open.

Import Button.png Update will import updated currency rates from the accounting integration.

Email Button.png Email opens a window to compose an email. If the module's default report is specified, the PDF report will be attached. Email can be configured on the Email tab of the Icon.Settings.png Settings module.

Print Button.png Print sends the default module report to the printer.

How To Button.png How To opens this article in a web browser.

Refresh Button.png Refresh reloads whatever is currently open in the module.

Create a currency

Follow the steps below to create a new currency.

  1. Open the Icon.Currency.png Currency module and click the New Button.png New button located on the module toolbar.
    Create New Currency.png
  2. Select the Country of the alternate currency.
  3. If needed, modify the Name and Code.
  4. Enter the Rate to convert the home currency to the alternate currency and then click Save.

Edit, delete, or inactivate a currency

  • To edit a currency, double-click the currency in the search pane, make any changes, and then click the Save Button.png Save button located in the module toolbar.
  • To delete a currency, double-click the currency in the search pane and then click the Delete Button.png Delete button located in the module toolbar.
  • A currency cannot be deleted if it is in use by other modules. In this case, a currency can be inactivated by unchecking the Active checkbox and then clicking the Save Button.png Save button in the module toolbar. To view an inactive currency, select Inactive in the Status dropdown of the search pane.

Update currency rates

Currency rates can be updated using any of the following methods.

Currency conversion for purchase orders

To see the currency conversion features available in the Purchase Order module, see Purchase Order Currency Conversion.

Currency conversion for sales orders

To see the currency conversion features available in the Sales Order module, see Sales Order Currency Conversion.


Some aspects of the Icon.Currency.png Currency module can be customized by opening the module, clicking the Tools menu, and then selecting Module Options.

General tab
Currency Module Option General.png
  • Use Currency Conversion
When the currency conversion option is checked, Fishbowl supports currency conversion in the Purchase Order and the Sales Order modules. If this option is unchecked, all of the fields related to currency conversion will be hidden throughout Fishbowl.
NOTE: The currency of a customer or vendor can only be changed when the customer is new. After orders have been created for a customer or vendor, the Currency field on the Details tab will be disabled.
  • Always display the currency code for reports
Displays the three letter currency code on reports.
  • Set default home currency
Select the default home currency to use in Fishbowl.
  • Set default home country
The default home country is selected when creating a database.