From Fishbowl
Revision as of 15:12, 7 February 2020 by Ncarter (talk | contribs) (Text replacement - "Imports_and_Exports#List_of_imports_and_exports||" to "Imports_and_Exports#List_of_imports_and_exports|")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, 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 Small.Sales Order.png Sales Order module and the Small.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 Small.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 Small.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 Small.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.
  • 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.